Maintained with ☕️ by
IcePanel logo

BigQuery migration assessment now includes support for Amazon Redshift Serverless

Share

Services

## Feature [BigQuery migration assessment](https://cloud.google.com/bigquery/docs/migration-assessment) now includes support for Amazon Redshift Serverless. This feature is in [ preview](https://cloud.google.com/products#product-launch-stages). ## Feature You can now generate structured data by using BigQuery ML's [AI.GENERATE\_TABLE function](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-generate-table) with Gemini 1.5 Pro, Gemini 1.5 Flash, and Gemini 2.0 Flash models. You can use the `AI.GENERATE_TABLE` function's `output_schema` argument to more easily format the model's response. The `output_schema` argument lets you specify a SQL schema for formatting, similar to the schema used in the `CREATE TABLE` statement. By creating structured output, you can more easily convert the function output into a BigQuery table. Try this feature with the [Generate structured data by using the AI.GENERATE\_TABLE function](https://cloud.google.com/bigquery/docs/generate-table) tutorial. This feature is in [preview](https://cloud.google.com/products/#product-launch-stages).