Loading

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

Publiseringsdato: May 3, 2026
Beskrivelse
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. 
Løsning
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-artikkelnummer

001474153

 
Laster
Salesforce Help | Article