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 On Sunday, January 30, 2022 at 1:12:44 PM UTC-5 Paul Swanson wrote: > 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 > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-appengine+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/ac472960-094a-4734-bc6b-8aaaa7aec7b7n%40googlegroups.com.
