Big Query: Query Failed. Dataset Not Found

Query Failed\nError: Not found: Dataset <project-id>:<table-name>. Please verify that the dataset exists and the correct location was used for the job.

\n\n

Here's my query\nSELECT distinct(customer_id) as cust_id FROM [<project-id>:<table-name>.orders] LIMIT 1000

\n\n

Is there anything wrong?\nOr how should I query an imported table?

\nSolution:

The correct naming for project-qualified table definitions is the following:

\n\n
#legacySQL\n[PROJECT_ID:DATASET.TABLE]\n\n#standardSQL\n`PROJECT_ID.DATASET.TABLE`

Ryan-Dallas

posted on

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds