Cannot reference a standard SQL view in a legacy SQL query - GBQ & IICS

Question

I am relatively new to GBQ. I am trying to create a mappping in IICS to copy one view from GBQ to create a table within GBQ. At this point I am not doing any transformations, just a source to target copy. I am getting the below error - [ERROR] The [QUERY] job failed with the error - [Cannot reference a standard SQL view in a legacy SQL query.]

Note that the IICS mapping is showing as valid and upon running the mapping the target table is dynamically getting created in GBQ but the mapping is failing throwing the above error. Please help.

Thanks

Answer 1

BigQuery supports two SQL dialects: standard SQL and legacy SQL and they cannot be mixed while can perfectly be running separately and in parallel

So, in your case looks like you are have Query that is written in Legacy SQL and that query references the view written in Standard SQL

The best way to handle this "issue" is to rewrite your query using Standard SQL

See Migrating to Standard SQL for details