steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_container_type

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

Examples

List container types of an application

select
  name,
  amount
from
  scalingo_container_type
where
  app_name = 'caresteouvert-api';

Count the number of all container types

select
  sum(amount)
from
  scalingo_container_type
where
  app_name = 'caresteouvert-api';

Schema for scalingo_container_type

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
amount	bigint		Amount of containers of the given type.
app_id	text		ID of the application.
app_name	text	=	Name of the app.
command	text		Command used to run the container.
name	text		Type of container (web, worker, etc.).
size	text		Size of the containers of this type (S/M/XL/..).
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.