Setting regions when creating a scheduled query in BQ

[Paul Swanson]

Hello,

I'm pretty new to using GCP and BigQuery, and I've run into an issue I was hoping someone might be able to help with.

I have several tables added in BigQuery that are coming from Google Sheets. I would like to create a scheduled query that pulls that data together, but when I try to create this I get a message stating: "Error creating scheduled query: Cannot create a transfer in JURISDICTION_US when destination dataset is located in REGION_ASIA_SOUTHEAST_1"

The GCP instance is set in REGION_ASIA_SOUTHEAST_1 because the school where I work is in Singapore and that seems likely to have the lowest latency, but I'm not sure how to set the Jurisdiction so that it matches. I have created a successful scheduled query before based on CSVs that I have uploaded, so my hunch is that the problem is the Google Sheet source for this data, but I'm not sure what to do about the issue.

Thanks in advance for your help!

Paul

DISCLAIMER NOTICE

Stamford American International School ("SAIS") is part of the Cognita group. The information contained in this e-mail and any attachments is confidential and may be the subject of legal, professional or other privilege. It is intended only for the named addressee (s) and may not be disclosed to anyone else without the consent of Cognita Ltd. If you are not the named addressee you must not use, disclose, distribute, copy, print or rely on the contents of the e-mail and should return it to sender immediately.

Cognita Ltd may monitor outgoing and incoming e-mails. By replying to this e-mail you give your consent to such monitoring.

Cognita Ltd do not accept any liability for any form of viruses introduced with this e-mail or its attachments.

Registered in England
Cognita Limited No. 5280910
Registered Office: Seebeck House, One Seebeck Place, Knowlhill, Milton Keynes, MK5 8FR

[Olu]

Hello Paul,

There are a number of reasons why this error may be obtained. It could be about your configurations, at the same time, there was a report of the error being related to a Console UI issue. So, the first step is to ensure that your configurations are right. 

I will like to point you to these Stackoverflow links[0][1] where similar concerns were reported. There are a few recommendations and suggestions from the Community on what to do about your setup. If the issue persists about the changes, then we may be able to help further at that point. 

[0]https://stackoverflow.com/questions/60259740/bigquery-scheduled-query-cannot-create-a-transfer-in-jurisdiction-us-when-des

[1]https://stackoverflow.com/questions/65398176/bigquery-scheduled-query-cannot-create-a-transfer-in-jurisdiction-us-when-desti?rq=1