Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

BIGQUERY

Hey i'am new to Query and I keep getting the same error message when I try to pull the data. can anyone please give some  feedback. If anyone is registered in the google data analytics course its course 4 week 3. Screenshot 2023-04-16 at 12.30.46 AM.png

0 1 130
1 REPLY 1

Hi there,

This error occurs when your bigquery editor settings are default set to US region whereas the table you are querying no in the US region.

If you click on in your bigquery editor page -> More -> Query Settings -> Advance Options -> Location Type - here you can set the region where you table is.

With above, there are chances that the query settings may again revert to US, therefore, to set default to region where your tables are see this documentation

Hope this helped