如何更改BigQuery控制台(Web UI)中的默认选项，尤其是取消选中“使用旧版SQL"? [英] How to change default Options in BigQuery console (Web UI), especially uncheck "Use Legacy SQL"?

问题描述

每次通过单击显示选项"显示此内容后，每次都要撰写查询"时都要取消选中使用旧版SQL"复选框.

Every time when I Compose Query have to uncheck box "Use Legacy SQL" after reveal this by clicking 'Show Options'.

这是浪费时间，因为在大多数情况下，我使用标准SQL.

It's waste of time because in most cases I use standard SQL.

我知道可以通过设置查询前缀"( https://cloud.google.com/bigquery/docs/reference/standard-sql/enabling-standard-sql )， 但一直输入#standardSQL也可能很烦人.

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?

在新控制台中， standardSQL 是默认选项，只需单击->

in the new console standardSQL is default option, just click ->

推荐答案

虽然不能完全解决您的问题-但BigQuery小组正在研究更灵活的项目配置，以便用户可以更改不同的项目级别设置，包括该项目的默认SQL方言.

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.

这篇关于如何更改BigQuery控制台(Web UI)中的默认选项，尤其是取消选中“使用旧版SQL"?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！