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.
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