steampipe plugin install francois2metz/scalingo

Table: scalingo_deployment

List deployments associated to an app.

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

Examples

List all deployments of an application

select
created_at,
status,
user_username
from
scalingo_deployment
where
app_name = 'caresteouvert-api';

Get average deploy duration

select
mean(duration)
from
scalingo_deployment
where
app_name = 'caresteouvert-api';

Schema for scalingo_deployment

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
app_idtextID of the application where the event belong.
app_nametext=Name of the app.
created_attimestamp with time zoneCreation date of the event.
durationbigintDuration of the deployment.
git_reftextGit SHA.
idtext=Unique ID identifying the event.
imagetextLink to the resulting image.
image_sizebigintSize of the deployment image (in bytes).
registrytextName of the registry.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
stack_base_imagetextStack used as base image.
statustextStatus of the deployment.
user_emailtextEmail of the user.
user_idtextUnique id of the user.
user_usernametextUsername of the user.