Query: sql_instance_automated_backups_enabled

select
  self_link resource,
  case
    when backup_enabled then 'ok'
    else 'alarm'
  end as status,
  case
    when backup_enabled then title || ' automatic backups configured.'
    else title || ' automatic backups not configured.'
  end as reason,
  location as location,
  project as project
from
  gcp_sql_database_instance;