Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to change default Options in BigQuery console (Web UI), especially uncheck "Use Legacy SQL"?

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 -> enter image description here

like image 272
rtbf Avatar asked Feb 09 '17 08:02

rtbf


1 Answers

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.

like image 93
Mosha Pasumansky Avatar answered Sep 19 '22 23:09

Mosha Pasumansky