terraform.gcp.security.gcp-bigquery-dataset-encrypted-with-cmk.gcp-bigquery-dataset-encrypted-with-cmk

profile photo of semgrepsemgrep
Author
unknown
Download Count*

Ensure that BigQuery datasets are not anonymously or publicly accessible

Run Locally

Run in CI

Defintion

rules:
  - id: gcp-bigquery-dataset-encrypted-with-cmk
    patterns:
      - pattern: |
          resource "google_bigquery_dataset" $ANYTHING {
            ...
          }
      - pattern-not-inside: |
          resource "google_bigquery_dataset" $ANYTHING {
            ...
            default_encryption_configuration {
              ...
              kms_key_name = ...
              ...
            }
            ...
          }
    message: "Ensure that BigQuery datasets are not anonymously or publicly
      accessible\t"
    metadata:
      category: security
      technology:
        - terraform
        - gcp
      owasp:
        - A03:2017 - Sensitive Data Exposure
      cwe:
        - "CWE-320: CWE CATEGORY: Key Management Errors"
      references:
        - https://docs.bridgecrew.io/docs/google-cloud-policy-index
      subcategory:
        - audit
      likelihood: LOW
      impact: LOW
      confidence: LOW
      license: Commons Clause License Condition v1.0[LGPL-2.1-only]
      vulnerability_class:
        - Cryptographic Issues
    languages:
      - hcl
    severity: WARNING

Examples

gcp-bigquery-dataset-encrypted-with-cmk.tf

# fail
# ruleid: gcp-bigquery-dataset-encrypted-with-cmk
resource "google_bigquery_dataset" "fail" {
  dataset_id                  = "example_dataset"
  friendly_name               = "test"
  description                 = "This is a test description"
  location                    = "EU"
  default_table_expiration_ms = 3600000

  labels = {
    env = "default"
  }

  access {
    role          = "OWNER"
    special_group = "allAuthenticatedUsers"
  }

  access {
    role   = "READER"
    domain = "hashicorp.com"
  }
}

# ok: gcp-bigquery-dataset-encrypted-with-cmk
resource "google_bigquery_dataset" "pass" {
  dataset_id                  = var.dataset.dataset_id
  friendly_name               = var.dataset.friendly_name
  description                 = var.dataset.description
  location                    = var.location
  default_table_expiration_ms = var.dataset.default_table_expiration_ms

  default_encryption_configuration {
    kms_key_name = google_kms_crypto_key.example.name
  }
}