Skip to content

This repo contains Terraform code, how to create the datasets, tables , tables using partitioning, bigquery views, scheduled Query and for-each for creating more than one resources.

Notifications You must be signed in to change notification settings

pavans78/bq-resources-terraform

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Big Query-Terraform

Terraform for GCP Bigquery. This repo contains how to create the datasets, tables , tables using partitioning, bigquery views and scheduled Query.

Try it out

  1. Initialize your new Terraform configuration by running the terraform init command in the same directory as your main.tf file:

    terraform init
  2. See the execution plan by running the terraform plan command with var-file, var-file is the inputs of the variables:

    terraform plan -var-file=var.tfvars 

    The output has a + next to resources blocks(google_bigquery_dataset & google_bigquery_table) , meaning that Terraform will create these resources. Beneath that, it shows the attributes that will be set. When the value displayed is (known after apply), it means that the value won't be known until the resource is created.

    If anything in the plan seems incorrect or dangerous, it is shows the error messages.

  3. Apply you configuration now by running the command terraform apply:

    terraform apply plans.tfplan
  4. After deploying, it will print the names of the dataset and table.

    Outputs:
    dataset_id = "test_dataset_id"
    table = "table1"
  5. Clean up after you’re done:

    terraform destroy -var-file=var.tfvars 

This is not an official project and does not come with maintenance guarantees.

About

This repo contains Terraform code, how to create the datasets, tables , tables using partitioning, bigquery views, scheduled Query and for-each for creating more than one resources.

Topics

Resources

Stars

Watchers

Forks

Languages