Скачать или смотреть How to use LLMs in SQL Statements with Big Query ML

Google have introduced the ability to use LLMs within SQL queries in Google Big Query with Big Query ML.

The steps to get this running are:
Create a connection to Vertex within a Google Big Query
Give the Connection access to Vertex AI by adding the service account to a Vertex AI user role in IAM.
Create the model in a dataset
Query any data, just include a required field called prompt with you can concat fields and prompts together into.

I first came across this Google Big Query LLM functionality in this medium article so shoutout to Pooja and check out her article.   / bringing-gen-ai-to-the-data-in-bigquery  

Here is a link to the google documentation including models that are usable in this setup: https://cloud.google.com/bigquery/doc...