steampipe 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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
addon_idtext=ID of the addon.
app_nametext=Name of the app.
created_attimestamp with time zoneCreation date of the backup.
idtext=Unique ID identifying the backup.
methodtextThe method of the backup (periodic or manual).
nametextName of backup.
sizebigintSize of backup.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
started_attimestamp with time zoneStart date of the backup.
statustextStatus of the current backup.