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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-appengine/85038b95-8fad-4b18-91e8-d83d94b76149n%40googlegroups.com.
