Can I change the location of my BigQuery dataset on Google cloud?

0 votes
I had created a bigquery dataset initially specifying a geographical location. Now Is it possible to change the geographical location of the dataset?
Nov 15 in GCP by anonymous
• 4,330 points
25 views

1 answer to this question.

0 votes

You can set the geographic location at creation time only

After a dataset has been created, the location becomes immutable and can't be changed in the GCP Console, the classic BigQuery web UI, the command-line tool, or by calling the patch or update API methods.

BigQuery datasets are subject to the following limitations:

  • All tables referenced in a query must be stored in datasets in the same location.

  • When copying a table, the datasets containing the source table and destination table must reside in the same location.

  • Dataset names must be unique per project.

  • As you approach thousands of datasets in a project, classic UI performance begins to degrade, and listing datasets becomes slower.

answered Nov 15 by Sirajul
• 40,980 points

Related Questions In GCP

0 votes
1 answer
0 votes
1 answer

How to run a run a BigQuery job programmatically?

To run a job programmatically: Start the job ...READ MORE

answered Nov 15 in GCP by Sirajul
• 40,980 points
22 views
0 votes
1 answer

Does Google cloud platform (GCP) offer IaaS ? Or just PaaS?

GCP provides IaaS as well, although it ...READ MORE

answered Sep 20 in GCP by Sirajul
• 40,980 points
173 views
0 votes
1 answer

How do I create a VPCN (Virtual private cloud network) on Google Cloud?

You can connect various GCP resources to each ...READ MORE

answered Sep 23 in GCP by Sirajul
• 40,980 points
40 views
0 votes
1 answer

Cloud SQL of google cloud is IaaS or PaaS?

Cloud SQL is PAAS (Plaform As A ...READ MORE

answered Sep 23 in GCP by Sirajul
• 40,980 points
63 views