steampipe 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';

Schema for scalingo_environment

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
app_nametext=Name of the app.
idtextUnique ID of the variable.
nametextName of the variable.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
valuetextValue of the variable.