CODEWITHSUNDEEP
google-bigquery
Balkan
Balkan

Reputation: 711

Is it possible to set the default region in the BigQuery web console?

Is it possible to set the BigQuery default region for uploads and queries in the web console? Currently, when I go to create table, it defaults to the US region.

Upvotes: 3

Views: 5802

Answers (1)

Joan Grau Noël
Joan Grau Noël

Reputation: 3192

The region location of the BigQuery product is dataset-based. That means that all the tables in the same dataset will be in the same region.

When you create a new dataset via the console, you are prompted choose one of the following regions, but you cannot change the dataset location later.

However, if it's essential to have the dataset in another region, you can follow this steps to transfer the data to a new dataset in another location.

Upvotes: 1

Related Questions