BigQuery giving unrecognized error for table name

Aryan Mullick 0
Viewed 38
SELECT
    employees.name AS employee_name,
    employees.role AS employee_role,
    departments.name AS departments_name
FROM
  `my-project-41566-361115.employee_data.employees`
INNER JOIN `my-project-41566-361115.employee_data.departments`
ON employees.department_id = departments.department_id

Why did I get a BigQuery "unrecognized error for table name" error?

google-analytics inner-join join google-bigquery sql
1 Answers

Use [ ] quotation:

SELECT
employees.name AS employee_name,
employees.role AS employee_role,
departments.name AS departments_name
FROM [my-project-41566-361115].[employee_data].[employees]
INNER JOIN [my-project-41566-361115].[employee_data].[departments]
ON employees.department_id = departments.department_id
Hosein Hamedan0
Related