Loading

Error "Google BigQuery service was unable to compile the query" When Connecting with Custom SQL

Julkaisupäivä: May 3, 2026
Kuvaus
When previewing results or dragging a field into the view, one of the following error messages might occur:

An error occurred while loading the data. The Google BigQuery service was unable to compile the query. Field "[Field Name]" not found. 

An error occurred while communicating with the Google Big Query data source [CustomSQLQuery]. The Google BigQuery service was unable to compile the query. Field "[Field Name]" not found. 

Cause

Tableau Desktop does not alter custom SQL when sent to Google Big Query, so the syntax must include aliases. 
Ratkaisu
Ensure that the fields within the Custom SQL are aliased. For example, the below query would fail because the [payload.desc] field is not aliased. 
SELECT [created_at] AS [created_at],
  [public] AS [public],
  [actor] AS [actor],
  [payload.desc]
FROM [publicdata:samples.github_nested] [github_nested]
Knowledge-artikkelin numero

001474153

 
Ladataan
Salesforce Help | Article