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

  1. A project (e.g. bigquery-public-data)
  2. A database (e.g. hacker_news)
  3. 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