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, 2019 in GCP by anonymous
• 6,260 points
1,665 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.

Hope it helps!!

If you need to know more about Google Cloud, We recommend joining GCP Certification course today.

Thanks!

answered Nov 15, 2019 by Sirajul
• 59,070 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, 2019 in GCP by Sirajul
• 59,070 points
608 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, 2019 in GCP by Sirajul
• 59,070 points
3,475 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, 2019 in GCP by Sirajul
• 59,070 points
661 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, 2019 in GCP by Sirajul
• 59,070 points
1,617 views
0 votes
1 answer