Google BigQuery Reservation Bigquery Reservation

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

yu-yamada/terraform_gcp_assigment_test

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

Parameters

• id optional computed - string
• ignore_idle_slots optional - bool

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.

• location optional - string

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

• name required - string

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

• project optional computed - string
• slot_capacity required - number

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.

• timeouts single block
  • create optional - string
  • delete optional - string
  • update optional - string

Explanation in Terraform Registry

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

• API documentation
• How-to Guides
  • Introduction to Reservations