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_addon
An addon is a database or other things attached to an application.
The scalingo_addon
table can be used to query information about an addon, and you must specify which application in the where or join clause using the app_name
column.
Examples
List addons of an application
select provider_name, statusfrom scalingo_addonwhere app_name = 'caresteouvert-api';
Get the price of all addons of a given application
select sum(plan_price)from scalingo_addonwhere app_name = 'caresteouvert-api';
Schema for scalingo_addon
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
app_id | text | ID of the application which owns the addon. | |
app_name | text | = | Name of the app. |
deprovisioned_at | timestamp with time zone | When the addon has been removed/upgraded. | |
id | text | = | Unique ID identifying the addon. |
plan_description | text | Description of the plan. | |
plan_disabled | boolean | Is this plan disabled. | |
plan_disabled_alternative_plan_id | boolean | ID of other plan if this plan disabled. | |
plan_display_name | text | Display name of the plan. | |
plan_hds_available | boolean | is this plan HDS compliant. | |
plan_id | text | Id of the plan. | |
plan_name | text | Name of the plan. | |
plan_on_demand | boolean | Is this addon available only on demand. | |
plan_price | double precision | Price of the plan. | |
plan_sku | text | SKU of the plan. | |
provider_description | text | Description of the provider. | |
provider_hds_available | boolean | Is this addon HDS compliantName of the provider. | |
provider_id | text | Id of the provider. | |
provider_logo_url | text | Logo url of the provider. | |
provider_name | text | Name of the provider. | |
provider_short_description | text | Short description of the provider. | |
provisioned_at | timestamp with time zone | When the addon has been created. | |
resource_id | text | Resource reference. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
status | text | Current status of the addon. |