limitedDistribution · Industry Research
The AI.GENERATE function | BigQuery | Google Cloud Documentation
This document describes the AI.GENERATE function, which lets you analyze any combination of structured and unstructured data. You can choose to generate text or structured output according to a custom schema that you specify. The function works by sending requests to a Vertex AI Gemini model and returning a STRUCT that contains your generated data, the full model response, and a status.

Google Cloud's AI.GENERATE function in BigQuery empowers businesses to seamlessly convert unstructured data into structured insights, enhancing decision-making and operational efficiency.
Executive Summary
This document describes the AI.GENERATE function, which lets you analyze any combination of structured and unstructured data. You can choose to generate text or structured output according to a custom schema that you specify. The function works by sending requests to a Vertex AI Gemini model and returning a STRUCT that contains your generated data, the full model response, and a status.
Source: Google Cloud Documentation
Original Article: https://docs.cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-ai-generate
See ROI in 12 weeks
Stargo users see measurable return and operational profitability gains in just 12 weeks, with non-disruptive implementation in 4 weeks or less.