Control: Ensure that Cloud SQL database instances are configured with automated backups
Description
It is recommended to have all SQL database instances set to enable automated backups.
Usage
Run the control in your terminal:
powerpipe control run gcp_compliance.control.sql_instance_automated_backups_enabledSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run gcp_compliance.control.sql_instance_automated_backups_enabled --shareSQL
This control uses a named query:
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 projectfrom gcp_sql_database_instance;