francois2metz/scalingo

steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_environment

The scalingo_environment table can be used to query information about environment variables, and you must specify which application in the where or join clause using the app_name column.

Examples

List environment variables of an application

select
name,
value
from
scalingo_environment
where
app_name='caresteouvert-api';

Find apps with a specific environment variable value

select
a.name as app_name,
e.name as env_name
from
scalingo_app as a
join
scalingo_environment as e
on
a.name = e.app_name
where
e.value = 'my variable value'

.inspect scalingo_environment

An environment variable is used to configure your app.

NameTypeDescription
app_nametextName of the app.
idtextUnique ID of the variable.
nametextName of the variable.
valuetextValue of the variable.