You can now use the GROUP BY clause and the SELECT DISTINCT clause with the ARRAY and STRUCT data types

## 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).