Site icon Guides Info

Not found: Table project-id:employee_data.departments was not found in location US

So I am trying to follow along with a tutorial on SQL joins but when I try to run the query in which I join two tables I get the aforementioned error.

I have confirmed that the dataset does indeed reside as you can see in the following screenshot: [The dataset details page]

The query in question is the following:

SELECT
    emp.name,
    dept.name,
    emp.name
FROM
    `project-id.employee_data.employees` as emp
INNER JOIN
    `project-id.employee_data.departments` as dept
ON
    emp.department_id = dept.department_id

If I try to query either table individually, I don’t have any problems. It is only when I query them in the same place that it gives me an error. I made sure processing location is set to US in the query settings so location shouldn’t be an issue.

Exit mobile version