Error: Not found: Dataset my-project-name:domain_public was not found in location US

Question

I need to make a query for a dataset provided by a public project. I created my own project and added their dataset to my project. There is a table named: domain_public. When I make query to this table I get this error:

 Query Failed
Error: Not found: Dataset my-project-name:domain_public was not found in location US
Job ID: my-project-name:US.bquijob_xxxx

I am from non-US country. What is the issue and how to fix it please?

EDIT 1: I change the processing location to asia-northeast1 (I am based in Singapore) but the same error:

Error: Not found: Dataset censys-my-projectname:domain_public was not found in location asia-northeast1 

Here is a view of my project and the public project censys-io:

Please advise.

EDIT 2: The query I used to type is based on censys tutorial is:

#standardsql
SELECT domain, alexa_rank
FROM domain_public.current
WHERE p443.https.tls.cipher_suite = 'some_cipher_suite_goes_here';

When I changed the FROM clause to:

FROM `censys-io.domain_public.current`

And the last line to:

WHERE p443.https.tls.cipher_suite.name = 'some_cipher_suite_goes_here';

It worked. Shall I understand that I should always include the projectname.dataset.table (if I'm using the correct terms) and point the typo the Censys? Or is this special case to this project for some reason?

Answer 1

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` 

Answer 2

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

Answer 3

The problem turned out to be due to wrong table name in the FROM clause. The right FROM clause should be:

FROM `censys-io.domain_public.current`

While I was typing:

FROM domain_public.current

So the project name is required in the FROM and `` are required because of - in the project name.