I know Legacy SQL can be an issue to load from BigQuery to Tableau.
However, I find similar issues with standard SQL syntax. A query that runs smoothly on BigQuery (size 254M) can't be loaded into Tableau.
Error message is as follows:
While on BigQuery the same query runs smoothly.
Any idea how can the data be extracted?
I believe the following article will solve your issue :
Error "Google BigQuery service was unable to compile the query" When Connecting with Custom SQL | Tableau Software
Do you have anything commented out on the query?
I've found that can cause some issues and I've had to remove the commented out lines.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...