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
5,126 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,230 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,230 points
1,544 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,230 points
7,037 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,230 points
1,853 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,230 points
4,016 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP