You can now use the GROUP BY clause and the SELECT DISTINCT clause with the ARRAY and STRUCT data types
Share
Services
## Feature
You can now use the `GROUP BY` clause and the `SELECT DISTINCT` clause with the `ARRAY` and `STRUCT` data types. This feature is in [Preview](https://cloud.google.com/products#product-launch-stages).
## Feature
You can now [query data in AlloyDB using a federated query](https://cloud.google.com/bigquery/docs/alloydb-federated-queries). This feature is now [generally available](https://cloud.google.com/products/#product-launch-stages) (GA).
## Feature
The following [Gemini in BigQuery](https://cloud.google.com/gemini/docs/bigquery/overview) features are now [generally available](https://cloud.google.com/products#product-launch-stages) (GA):
* [Data insights](https://cloud.google.com/bigquery/docs/data-insights)
* [Data canvas](https://cloud.google.com/bigquery/docs/data-canvas)
* SQL and Python code assistance features:
* [Use the SQL generation tool](https://cloud.google.com/bigquery/docs/write-sql-gemini#use%5Fthe%5Fsql%5Fgeneration%5Ftool)
* [Prompt to generate SQL queries](https://cloud.google.com/bigquery/docs/write-sql-gemini#prompt%5Fto%5Fgenerate%5Fsql%5Fqueries)
* [Explain a SQL query](https://cloud.google.com/bigquery/docs/write-sql-gemini#explain%5Fa%5Fsql%5Fquery)
* [Generate Python code](https://cloud.google.com/bigquery/docs/write-sql-gemini#generate%5Fpython%5Fcode)
* [Partitioning and clustering recommendations](https://cloud.google.com/bigquery/docs/manage-partition-cluster-recommendations)
To learn how to enable and activate Gemini in BigQuery features, see [Set up Gemini in BigQuery](https://cloud.google.com/gemini/docs/bigquery/set-up-gemini).
## Feature
Phrase support for the [SEARCH function](https://cloud.google.com/bigquery/docs/reference/standard-sql/search%5Ffunctions#search) is now [generally available](https://cloud.google.com/products#product-launch-stages) (GA).
What else is happening at Google Cloud Platform?
Toxic combination findings are generally available. This includes the following updates
October 16th, 2024
Services
Share