Every time when I Compose Query have to uncheck box "Use Legacy SQL" after reveal this by clicking 'Show Options'.
It's waste of time because in most cases I use standard SQL.
I know there is some workaround for above by 'Setting a query prefix' (https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql), but typing all the time #standardSQL could be also annoying.
Is there any third party plugin or other option to change this default behaviour?
in the new console standardSQL is default option, just click ->
While not exactly the answer for your question - but BigQuery team is working on more flexible project config, such that users will be able to change different project level settings, including default SQL dialect for the project.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With