BigQuery连接表报错：Expected end of input but got identifier "bella_beat"

错误原因 #

BigQuery 解析包含连字符（-）的项目ID时，会默认将连字符识别为减法运算符，无法正确识别完整的项目.数据集.表路径，最终触发对应语法报错。

修复方案 #

所有包含连字符的项目路径，需要用反引号（`）完整包裹。也可以给表设置别名简化后续关联条件的写法，避免重复写长路径。

修正后可运行的SQL语句 #

SELECT 
  activity_tracker.id,
  LightlyActiveMinutes AS light_active_mins,
  FairlyActiveMinutes AS fairl_active_mins,
  VeryActiveMinutes AS very_active_mins,
  sleep_tracker.TotalMinutesAsleep AS total_sleep_mins,
  sleep_tracker.TotalTimeInBed AS total_bedtime_mins
FROM 
  `my-project-1-325906.bella_beat.activity_tracker` AS activity_tracker
JOIN 
  `my-project-1-325906.bella_beat.sleep_tracker` AS sleep_tracker
ON 
  activity_tracker.id = sleep_tracker.id

内容的提问来源于stack exchange，提问作者Debashis Chakravartti