Maintained with ☕️ by
IcePanel logo

You can now use the CREATE CONNECTION, ALTER CONNECTION SET OPTIONS,

Share

Services

## Feature Feature You can now use the[CREATE CONNECTION](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#create%5Fconnection%5Fstatement),[ALTER CONNECTION SET OPTIONS](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#alter%5Fconnection%5Fset%5Foptions%5Fstatement), and [DROP CONNECTION](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#drop%5Fconnection%5Fstatement)data definition language (DDL) statements to manage Cloud resource connections with GoogleSQL. Additionally, you can now use the[connection user type](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-control-language#user%5Flist)and [PROJECT resource type](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-control-language#arguments)with `GRANT` and `REVOKE` data control language (DCL) statements to manage connection and project access. These features are[generally available](https://cloud.google.com/products#product-launch-stages)(GA). ## Feature Feature The [BigQuery Migration Service supports SQL translations from Snowflake SQL to GoogleSQL](https://cloud.google.com/bigquery/docs/migration/snowflake-migration-intro). This feature is now [generally available](https://cloud.google.com/products#product-launch-stages) (GA). With this change, the translation service supports a wider variety of Snowflake SQL and has improved support for several data types. Among other changes, the translation service maps Snowflake`INTEGER` and zero-scale `NUMERIC` types up to precision 38 to `INT64` type in GoogleSQL for improved performance by default. ## Feature Feature You can set the[column granularity](https://cloud.google.com/bigquery/docs/search-index#column-granularity) when you[create a search index](https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#create%5Fsearch%5Findex%5Fstatement), which stores additional column information in your search index to further optimize your search query performance. This feature is[generally available](https://cloud.google.com/products#product-launch-stages)(GA).