steampipe plugin install francois2metz/scalingosteampipe plugin install francois2metz/scalingo

Table: scalingo_database_backup

List of backup of a database associated to an app.

The scalingo_database_backup table can be used to query information about a backup of addon database, and you must specify which application and addon in the where or join clause using the app_name and the addon_id columns.

Examples

Get Backup info

select
  created_at,
  size,
  status
from
  scalingo_database_backup
where
  app_name = 'caresteouvert-api'
  and addon_id = 'ad-0c33a92f-000-000-000-0000000';

List backups from all addons from all applications

with apps_and_addons as (
  select
    ad.id as addon_id,
    ad.app_name as app_name
  from
    scalingo_app app
    join scalingo_addon ad on ad.app_name = app.name
  order by
    app.id
)
select
  db.app_name,
  db.addon_id,
  bk.created_at,
  bk.size,
  bk.status
from
  scalingo_database_backup bk
  join apps_and_addons db on db.addon_id = bk.addon_id
  and db.app_name = bk.app_name;

Schema for scalingo_database_backup

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
addon_id	text	=	ID of the addon.
app_name	text	=	Name of the app.
created_at	timestamp with time zone		Creation date of the backup.
id	text	=	Unique ID identifying the backup.
method	text		The method of the backup (periodic or manual).
name	text		Name of backup.
size	bigint		Size of backup.
started_at	timestamp with time zone		Start date of the backup.
status	text		Status of the current backup.