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

Make sure your FROM location contains 3 parts as @stevec mentioned

• A project (e.g. bigquery-public-data)
• A database (e.g. hacker_news)
• A table (e.g. stories)

But in my case, I was using the LegacySql within the Google script editor, so in that case you need to state that to false, for example:

var projectId = 'xxxxxxx';
    
var request = {
  query: 'select * from project.database.table',
  useLegacySql: false
};
var queryResults = BigQuery.Jobs.query(request, projectId);

Answer 4

check exact case [upper or lower] and spelling of table or view name. copy it from table definition and your problem will be solved.

i was using FPL009_Year_Categorization instead of FPL009_Year_categorization

using c as C and getting the error "not found in location asia-south1"

I copied with exact case and problem is resolved.

Answer 5

On your Big Query console, go to the Data Explorer on the left pane, click the small three dots, then select query option from the list. This step confirms you choose the correct project and dataset. Then you can edit the query on the query pane on the right.

Answer 6

may be dataset name changed in create dataset option. it should be US or default location

enter image description here