steampipe plugin install francois2metz/scalingo

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,
status
from
scalingo_addon
where
app_name = 'caresteouvert-api';

Get the price of all addons of a given application

select
sum(plan_price)
from
scalingo_addon
where
app_name = 'caresteouvert-api';

Schema for scalingo_addon

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
app_idtextID of the application which owns the addon.
app_nametext=Name of the app.
deprovisioned_attimestamp with time zoneWhen the addon has been removed/upgraded.
idtext=Unique ID identifying the addon.
plan_descriptiontextDescription of the plan.
plan_disabledbooleanIs this plan disabled.
plan_disabled_alternative_plan_idbooleanID of other plan if this plan disabled.
plan_display_nametextDisplay name of the plan.
plan_hds_availablebooleanis this plan HDS compliant.
plan_idtextId of the plan.
plan_nametextName of the plan.
plan_on_demandbooleanIs this addon available only on demand.
plan_pricedouble precisionPrice of the plan.
plan_skutextSKU of the plan.
provider_descriptiontextDescription of the provider.
provider_hds_availablebooleanIs this addon HDS compliantName of the provider.
provider_idtextId of the provider.
provider_logo_urltextLogo url of the provider.
provider_nametextName of the provider.
provider_short_descriptiontextShort description of the provider.
provisioned_attimestamp with time zoneWhen the addon has been created.
resource_idtextResource reference.
statustextCurrent status of the addon.