BigQuery "... was not found in location US"

Viewed 13

I'm doing the google analytics Coursera certificate, and a came across the next situation in BigQuery.

enter image description here

As you can see I want to do a "inner join" from the departments and employees table, BUT, I'm getting an error, "...was not found in location US".

Am I doing something wrong or missing something? Both of the tables have "data location: US"

SELECT
  employees.name AS employee_name,
  employees.role AS employee_role,
  departments.name AS departmen_name
FROM
  employee_data.employees
INNER JOIN
  employee_data.departments ON
  employees.department_id = departments.department_id

Thanks in advance

0 Answers
Related