知識庫

Google BigQuery service was unable to compile the query. Unrecognized name: `person.name.first`


發佈時間 : 22 Dec 2016
上次修改日期 : 20 Jul 2023

問題

When connecting to BigQuery data source from Tableau Desktop then receives error:
 
The Google BigQuery service was unable to compile the query. Unrecognized name: `person.name.first` at [1:37]

環境

  • Tableau Desktop
  • Windows 10
  • Google BigQuery

解決方法

Option 1

Fields must contain only letters, numbers, and underscores, start with a letter or underscore, and be at most 128 characters long.


Option 2

When connecting to Google BigQuery, select the "Use Legacy SQL" option in Tableau Desktop. For more information, see Check if your workbook uses standard SQL or legacy SQL in Tableau Help.

原因

This is an issue within Google BigQuery. 
這篇文章是否解決了問題?