BigQuery连接两张表报错：Unrecognized name: employees

错误原因 #

问题出在未给表显式指定别名，导致BigQuery无法识别你在SELECT和ON子句中使用的employees、departments标识符。

当你使用完整的「项目ID-数据集-表」路径（如my-project-050923-386223.employee_data.employees）引用表时，BigQuery会将这个完整路径视为表的唯一标识符，而非路径末尾的employees短名称。因此你必须通过AS关键字为表设置别名，才能在后续查询中用短名称引用表内字段。

修改后的代码 #

你可以选择用简短别名简化代码：

SELECT
  emp.name AS employee_name,
  emp.role AS employee_role,
  dept.name AS department_name
FROM
  `my-project-050923-386223.employee_data.employees` AS emp
INNER JOIN
  `my-project-050923-386223.employee_data.departments` AS dept 
  ON emp.department_id = dept.department_id;

也可以保留原表名作为别名，无需修改字段引用部分：

SELECT
  employees.name AS employee_name,
  employees.role AS employee_role,
  departments.name AS department_name
FROM
  `my-project-050923-386223.employee_data.employees` AS employees
INNER JOIN
  `my-project-050923-386223.employee_data.departments` AS departments 
  ON employees.department_id = departments.department_id;

简化写法（可选） #

如果你已经在BigQuery界面中选中了employee_data数据集，还可以省略项目和数据集前缀，直接写表名：

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

内容的提问来源于stack exchange，提问作者Cindy Singleton