BigQuery Error loading location is interrupting scheduled queries

user_3648408 0
Viewed 457

A few days ago, I started receiving an error in my Scheduled Queries dashboard Error loading location europe-west8: BigQuery Data Transfer Service does not yet support location: europe-west8.

I'm in the US, so I have set all 4 of my storage buckets are set to US or REGION, and have confirmed their locations.

enter image description here

Datasets are all US: enter image description here

Scheduled queries are all Region "us"

Since this error started, my BigQuery Scheduled Queries that append data to tables have stopped running.

Where can I change the setting that seems to be calling europe-west8?

google-bigquery
2 Answers

You need to check the region of the dataset you are using. The destination table for your scheduled query must be in the same region as the data being queried.

You can see the scheduled queries are supported in these locations here.

You specify a location for storing your BigQuery data when you create a dataset. After you create the dataset, the location cannot be changed, but you can copy the dataset to a different location, or manually move (recreate) the dataset in a different location.

You can see more information about how locations work in BigQuery here.

EDIT

This is a known issue from BigQuery UI, and the engineering team is aware of and is working towards a solution, although so far there isn't a specific ETA. Feel free to start the issue to raise further awareness towards it.

There are two possible workarounds you can try to circumvent this.

More specifically,

  • Workaround#1

    Using the old UI, you can do it by clicking on "Disable editor tabs".

enter image description here

  • Workaround#2
    • In Scheduled Query Editor > click the SCHEDULE dropdown > choose "Enable scheduled queries".
    • The overlay shows up with the message box ("Enable scheduled queries").
    • Click anywhere on the screen to close the overlay
    • Click the SCHEDULE dropdown again, and the create/update options are there.
user_169291450
user_132542480
Related