turbot/gcp_insights

Query: sql_database_instance_backup_enabled

Usage

powerpipe query gcp_insights.query.sql_database_instance_backup_enabled

SQL

select
'Backup' as label,
case
when backup_enabled then 'Enabled'
else 'Disabled'
end as value,
case
when backup_enabled then 'ok'
else 'alert'
end as "type"
from
gcp_sql_database_instance
where
project = split_part($1, '/', 7)
and self_link = $1;

Dashboards

The query is used in the dashboards: