Learning Google BigQuery

Qualifying tables in query

The table name must be preceded by the dataset name if the query is being run against the current project or default project. If the query uses tables from other projects, then the project name must also be added to the qualifier. The following examples show how to qualify the tables in legacy SQL and standard SQL.

If the table being queried is located in the default project or currently selected project in the BigQuery console, then the project name is optional. In legacy SQL, the table and its qualifier are enclosed within []. In the following example, HumanResourceDS is the dataset name, and it is followed by the table name with a . between the dataset name and table name:

#legacySQLSELECT Employee_ID, Employee_Joining_Date, ...