steampipe plugin install francois2metz/scalingo

Table: scalingo_app

An application is the base object of the scalingo API.

The scalingo_app table can be used to query information about any applications.

Examples

List applications

select
name,
region,
url
from
scalingo_app;

Get stopped applications

select
name
from
scalingo_app
where
status = 'stopped';

Schema for scalingo_app

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
base_urltextURL generated by Scalingo for your app.
created_attimestamp with time zoneCreation date of the application.
data_access_consent_containers_untiltimestamp with time zoneEnd date when data operators can inspect containers.
data_access_consent_databases_untiltimestamp with time zoneEnd data when data operator can inspect databases.
data_access_consent_user_idtextUnique ID of the user who allowed data operators to inspect the application.
flagsjsonbList of flags associated to the app.
force_httpsbooleanActivation of force HTTPS.
git_urltextURL to the GIT remote to access your application.
hds_resourcebooleanTrue if the app is HDS.
idtextUnique id of the application.
last_deployed_attimestamp with time zoneDate of the last deployment attempt.
last_deployed_bytextUser who attempted the last deployment.
limitsjsonbList of limits associated to the app.
nametext=Name of the application.
owner_emailtextEmail of the owner.
owner_idtextUnique id of the owner.
owner_usernametextUsername of the owner.
private_networks_idsjsonbIDs of the private networks.
regiontextRegion of the application.
router_logsbooleanActivation of the router logs in your app logs.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
stack_idtextID of the stack used.
statustextStatus of the application.
sticky_sessionbooleanActivation of sticky session.
updated_attimestamp with time zoneLast time the application has been updated.
urltextURL used to access your app.