Policy: GCP > SQL > Instance > Data Protection > Managed Backups

Guardrails can automate taking SQL backups and manage the retention of these backups.

This policy enables / disables that feature, enforcing the schedule in the Managed Backups > Schedule and Managed Backups > Minimum Schedule sub-policies.

Resource Types

This policy targets the following resource types:

GCP > SQL > Instance

Primary Policy

This policy is used with the following primary policy:

GCP > SQL > Instance > Data Protection

Controls

GCP > SQL > Instance > Data Protection

Policy Packs

This policy setting is used by the following policy packs:

GCP CIS v2.0.0 - Section 6 - Cloud SQL Database Services

Policy Specification

Schema Type	`string`
Default	`Skip`
Valid Values [YAML]	`Skip` `>- Enforce: Manage snapshots, per Managed Backups > Schedule and Managed Backups > Minimum Schedule`

In Your Workspace

Policy Settings by Type report

Developers

Category URI

tmod:@turbot/turbot#/control/categories/resourceDataProtection

Policy Type URI

tmod:@turbot/gcp-sql#/policy/types/instanceDataProtectionManagedBackups

GraphQL

query policyType(id: "tmod:@turbot/gcp-sql#/policy/types/instanceDataProtectionManagedBackups") { … }

query policySettings(filter: "policyTypeId:'tmod:@turbot/gcp-sql#/policy/types/instanceDataProtectionManagedBackups'") { … }

query policyValues(filter: "policyTypeId:'tmod:@turbot/gcp-sql#/policy/types/instanceDataProtectionManagedBackups'") { … }

CLI

Get Policy Type

turbot graphql policy-type --id "tmod:@turbot/gcp-sql#/policy/types/instanceDataProtectionManagedBackups"

Get Policy Settings

turbot graphql policy-settings --filter "policyTypeId:tmod:@turbot/gcp-sql#/policy/types/instanceDataProtectionManagedBackups"