steampipe plugin install francois2metz/scalingosteampipe 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

select
  name,
  region,
  url
from
  scalingo_app;

select
  name
from
  scalingo_app
where
  status = 'stopped';

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
base_url	text		URL generated by Scalingo for your app.
created_at	timestamp with time zone		Creation date of the application.
data_access_consent_containers_until	timestamp with time zone		End date when data operators can inspect containers.
data_access_consent_databases_until	timestamp with time zone		End data when data operator can inspect databases.
data_access_consent_user_id	text		Unique ID of the user who allowed data operators to inspect the application.
flags	jsonb		List of flags associated to the app.
force_https	boolean		Activation of force HTTPS.
git_url	text		URL to the GIT remote to access your application.
hds_resource	boolean		True if the app is HDS.
id	text		Unique id of the application.
last_deployed_at	timestamp with time zone		Date of the last deployment attempt.
last_deployed_by	text		User who attempted the last deployment.
limits	jsonb		List of limits associated to the app.
name	text	=	Name of the application.
owner_email	text		Email of the owner.
owner_id	text		Unique id of the owner.
owner_username	text		Username of the owner.
region	text		Region of the application.
router_logs	boolean		Activation of the router logs in your app logs.
stack_id	text		ID of the stack used.
status	text		Status of the application.
sticky_session	boolean		Activation of sticky session.
updated_at	timestamp with time zone		Last time the application has been updated.
url	text		URL used to access your app.