CODEWITHSUNDEEP
google-bigquerytableau-api
Jaison
Jaison

Reputation: 762

Tableau - Unable to execute BigQuery view which is created using standard SQL

I'm unable to execute a BigQuery view which created using Standard SQL. Below is the error:

The Google BigQuery service was unable to compile the query.  Cannot reference a SQL view in a Legacy SQL query.

Tableau version - 9.3

Upvotes: 1

Views: 2144

Answers (1)

Elliott Brossard
Elliott Brossard

Reputation: 33745

From the migration guide, you cannot query a logical view defined with legacy SQL using standard SQL and vice versa due to differences in syntax and semantics between the dialects. In order to query the view, you will need to use standard SQL.

See also the Tableau help page about switching between the dialects.

Upvotes: 3

Related Questions