v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins

francois2metz/scalingo

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.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
started_at	timestamp with time zone		Start date of the backup.
status	text		Status of the current backup.