When using an SQL Statement with a WITH Query Expression I am getting the following error: No select statement found. I was told that WITH statements are currently not supported at the moment.
Why this should be changed:
- WITH statements are very important to structure long and complex SQL scripts and reducing heavily nested (unreadable) SQL scripts.
- We have a lot of scripts that we want to migrate, but we are stuck as it would take too much time and effort to transform the script. Same for moving logic to Dataprep recipes.
Best regards
Marcel
Details about the syntax:
https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax
Related customer questions
- https://community.trifacta.com/s/question/0D53j00006OatIdCAJ/is-it-possible-to-use-cte-common-table-expressions-when-importing-a-data-set-using-custom-sql-i-am-specifically-trying-to-use-with-statements