BigQuery Infrastructure as Code

Managing BigQuery resources using Infrastructure as Code (IaC) ensures consistency and repeatability across environments.

Terraform

The Google Cloud Terraform provider supports BigQuery datasets, tables, jobs, and reservations.

Dataset and Table Example

resource "google_bigquery_dataset" "dataset" {
  dataset_id                  = "example_dataset"
  friendly_name               = "test"
  description                 = "This is a test description"
  location                    = "US"
  default_table_expiration_ms = 3600000

  labels = {
    env = "default"
  }
}

resource "google_bigquery_table" "default" {
  dataset_id = google_bigquery_dataset.dataset.dataset_id
  table_id   = "example_table"

  time_partitioning {
    type = "DAY"
  }

  labels = {
    env = "default"
  }

  schema = <<EOF
[
  {
    "name": "name",
    "type": "STRING",
    "mode": "REQUIRED",
    "description": "The user's name"
  },
  {
    "name": "age",
    "type": "INTEGER",
    "mode": "NULLABLE",
    "description": "The user's age"
  }
]
EOF
}

Reference Documentation

YAML Samples

BigQuery resources can also be managed via Deployment Manager or other tools using YAML configurations.

BigQuery YAML Samples

1.7 KiB Raw Permalink Blame History

BigQuery Infrastructure as Code

Terraform

Dataset and Table Example

Reference Documentation

YAML Samples

1.7 KiB

Raw Permalink Blame History