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

Question

I had created a bigquery dataset initially specifying a geographical location. Now Is it possible to change the geographical location of the dataset?

Answer 1

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!

Comments

But you can move your project to a new (required) location.