11 June 2019 · Ryan-Dallas ·       Add to Favorites   Report

Big Query: Query Failed. Dataset Not Found

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

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

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

Solution:

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

#legacySQL
[PROJECT_ID:DATASET.TABLE]

#standardSQL
`PROJECT_ID.DATASET.TABLE`

Ryan-Dallas

posted on 11 June 2019

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied