steampipe plugin install francois2metz/scalingo

Table: scalingo_database_maintenance

List maintenance of databases.

You must specify app_name and addon_id in a where clause in order to use this table.

Examples

List maintenance of a database

select
type,
status,
started_at
from
scalingo_database_maintenance
where
app_name = 'caresteouvert-api'
and addon_id = 'ad-0c33a92f-000-000-000-0000000';

List scheduled maintenance of a database

select
type,
status,
started_at
from
scalingo_database_maintenance
where
app_name = 'caresteouvert-api'
and addon_id = 'ad-0c33a92f-000-000-000-0000000'
and status = 'scheduled';

Get one maintenance

select
type,
status,
started_at
from
scalingo_database_maintenance
where
app_name = 'caresteouvert-api'
and addon_id = 'ad-0c33a92f-000-000-000-0000000'
and id = '60a4ab3d406c12000eed29e7';

Schema for scalingo_database_maintenance

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
addon_idtext=ID of the addon.
app_nametext=Name of the app.
ended_attimestamp with time zoneEnd date of the maintenance.
idtext=Unique ID identifying the maintenance.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
started_attimestamp with time zoneStart date of the maintenance.
statustextStatus of the maintenance (scheduled, notified, queued, cancelled, running, failed, done).
typetextType of the maintenance (no-op, failing).