do you not need to change group by 1,2,3,4 to group by user_id, profile_email, ...etc
i.e. use specific named columns?
It works fine with group by 1,2,3,4 when I do the query on Google BigQuery. But still I made the change and I still get the same error.
Tableau wraps your custom SQL in a further select clause and it is probably the combination that is giving Google BigQuery trouble. You can see the full SQL statement in Tableau logs.
Please find the full SQL statement in the Tableau logs and either post the SQL here or send the logs to support.
3 of 3 people found this helpful
The issue was corrected by changing the comments syntax :
-- hits -------> /* hits */
And it worked flawlessly.
Glad you figured it out. The BigQuery documentation doesn't actually say what kinds of comments are allowed. But I can't see any problem on Tableau's side.