Error: Not found: Dataset my-project-name:domain_public was not found in location US
BigQuery can't find your data
How to fix it
Make sure your FROM
location contains 3 parts
- A project (e.g.
bigquery-public-data
) - A database (e.g.
hacker_news
) - A table (e.g.
stories
)
Like so
`bigquery-public-data.hacker_news.stories`
*note the backticks
Examples
Wrong
SELECT *
FROM `stories`
Wrong
SELECT *
FROM `hacker_news.stories`
Correct
SELECT *
FROM `bigquery-public-data.hacker_news.stories`
In Web UI - click Show Options button and than select your location for "Processing Location"!
Specify the location in which the query will execute. Queries that run in a specific location may only reference data in that location. For data in US/EU, you may choose Unspecified to run the query in the location where the data resides. For data in other locations, you must specify the query location explicitly.
Update
As it stated above - Queries that run in a specific location may only reference data in that location
Assuming that censys-io.domain_public
dataset has its data in US - you need to specify US for Processing Location