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:

    `project-id.employee_data.employees` as emp
    `project-id.employee_data.departments` as dept
    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.