Generative AI over Structured Data

BigQuery ML now integrates directly with Vertex AI foundation models. You can run Gemini over millions of rows of text data directly within a SQL query.

SELECT * FROM ML.GENERATE_TEXT(
  MODEL `my_dataset.gemini_pro_model`,
  (SELECT text_column as prompt FROM `my_dataset.reviews`),
  STRUCT(0.2 AS temperature, 100 AS max_output_tokens)
);

This allows you to perform sentiment analysis, summarization, and entity extraction on massive datasets in seconds.