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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
app_id	text		ID of the application where the event belong.
app_name	text	=	Name of the app.
created_at	timestamp with time zone		Creation date of the event.
duration	bigint		Duration of the deployment.
git_ref	text		Git SHA.
id	text	=	Unique ID identifying the event.
image	text		Link to the resulting image.
image_size	bigint		Size of the deployment image (in bytes).
registry	text		Name of the registry.
stack_base_image	text		Stack used as base image.
status	text		Status of the deployment.
user_email	text		Email of the user.
user_id	text		Unique id of the user.
user_username	text		Username of the user.