terraform.gcp.best-practice.gcp-gke-sql-backup-configuration-enabled.gcp-gke-sql-backup-configuration-enabled

profile photo of semgrepsemgrep
Author
unknown
Download Count*
LGPL Commons Clause
License

Ensure all Cloud SQL database instance have backup configuration enabled

Run Locally

Run in CI

Semgrep CI docs

Defintion

Edit RuleView Source
Open in Playground 
rules:
  - id: gcp-gke-sql-backup-configuration-enabled
    patterns:
      - pattern: resource
      - pattern-inside: |
          resource "google_sql_database_instance" "..." {
          ...
          }
      - pattern-not-inside: |
          resource "google_sql_database_instance" "..." {
          ...
          settings {
            ...
            backup_configuration {
              ...
              enabled = true
              ...
            }
            ...
          }
          ...
          }
    message: Ensure all Cloud SQL database instance have backup configuration enabled
    metadata:
      category: best-practice
      technology:
        - terraform
        - gcp
      license: Commons Clause License Condition v1.0[LGPL-2.1-only]
    languages:
      - hcl
    severity: WARNING

Examples

gcp-gke-sql-backup-configuration-enabled.tf

# fail
# ruleid: gcp-gke-sql-backup-configuration-enabled
resource "google_sql_database_instance" "fail" {
  database_version = "MYSQL_8_0"
  name             = "instance"
  region           = "us-central1"
  settings {
    tier = "db-f1-micro"
  }
}

# ok: gcp-gke-sql-backup-configuration-enabled
resource "google_sql_database_instance" "success" {
  database_version = "MYSQL_8_0"
  name             = "instance"
  region           = "us-central1"
  settings {
    tier = "db-f1-micro"
    backup_configuration {
        enabled = true
        start_time = "17:00"
    }
  }
}