scalingo_addonscalingo_alertscalingo_appscalingo_app_eventscalingo_autoscalerscalingo_collaboratorscalingo_containerscalingo_container_typescalingo_cronscalingo_databasescalingo_database_backupscalingo_database_maintenancescalingo_database_type_versionscalingo_database_userscalingo_deploymentscalingo_domainscalingo_environmentscalingo_event_typescalingo_invoicescalingo_keyscalingo_log_drainscalingo_log_drain_addonscalingo_notification_platformscalingo_notifierscalingo_regionscalingo_scm_integrationscalingo_scm_repo_linkscalingo_stackscalingo_tokenscalingo_user_eventscalingo_user_scm_repo_link
Table: scalingo_domain
List domains associated to an app.
The scalingo_domain
table can be used to query information about domains, and you must specify which application in the where or join clause using the app_name
column.
Examples
List domains of an application
select name, ssl, canonicalfrom scalingo_domainwhere app_name = 'caresteouvert-api';
Schema for scalingo_domain
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
acme_dns_error | text | ACME DNS-01 error. | |
acme_dns_fqdn | text | ACME DNS-01 TXT entry FQDN. | |
acme_dns_value | text | ACME DNS-01 TXT entry value. | |
app_id | text | ID of the application where the domain belong. | |
app_name | text | = | Name of the app. |
canonical | boolean | The domain is the canonical domain of this application. | |
id | text | = | Unique ID identifying the domain. |
lets_encrypt | boolean | The domain is using a Let’s Encrypt certificate. | |
lets_encrypt_status | text | Let’s Encrypt certificate generation status. | |
name | text | Hostname your want to associate with the app. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
ssl | boolean | Flag if SSL with a custom certificate is enabled. | |
ssl_status | text | SSL certificate status (pending, success, error). | |
tls_cert | text | Subject of the submitted certificate. | |
tls_key | text | Private key type and length. | |
validity | timestamp with time zone | Once a certificate has been submitted, display the validity of it. |