Google BigQuery Reservation Bigquery Reservation

This page shows how to write Terraform for BigQuery Reservation Bigquery Reservation and write them securely.

google_bigquery_reservation (Terraform)

The Bigquery Reservation in BigQuery Reservation can be configured in Terraform with the resource name google_bigquery_reservation. The following sections describe 1 example of how to use the resource and its parameters.

Example Usage from GitHub
resource "google_bigquery_reservation" "reservation-test01" {
  name              = "test01"
  location          = "US"
  slot_capacity     = 100
  ignore_idle_slots = false
  project           = var.gcp_project

Review your Terraform file for Google best practices

Shisho Cloud, our free checker to make sure your Terraform configuration follows best practices, is available (beta).


If false, any query using this reservation will use idle slots from other reservations within the same admin project. If true, a query using this reservation will execute with the slot capacity specified above at most.

The geographic location where the transfer config should reside. Examples: US, EU, asia-northeast1. The default value is US.

The name of the reservation. This field must only contain alphanumeric characters or dash.

Minimum slots available to this reservation. A slot is a unit of computational power in BigQuery, and serves as the unit of parallelism. Queries using this reservation might use more slots during runtime if ignoreIdleSlots is set to false.

Explanation in Terraform Registry

A reservation is a mechanism used to guarantee BigQuery slots to users. To get more information about Reservation, see:

Frequently asked questions

What is Google BigQuery Reservation Bigquery Reservation?

Google BigQuery Reservation Bigquery Reservation is a resource for BigQuery Reservation of Google Cloud Platform. Settings can be wrote in Terraform.

Where can I find the example code for the Google BigQuery Reservation Bigquery Reservation?

For Terraform, the yu-yamada/terraform_gcp_assigment_test source code example is useful. See the Terraform Example section for further details.


Automate config file reviews on your commits

Fix issues in your infrastructure as code with auto-generated patches.