Skip to content

Instantly share code, notes, and snippets.

View jeffonelson's full-sized avatar

Jeff Nelson jeffonelson

View GitHub Profile
@jeffonelson
jeffonelson / bq_gemini3_preview.sql
Last active February 26, 2026 16:51
Use Gemini 3.0 Pro with BigQuery.
# Just replace <project_id> in the endpoint argument with your own project to run this query!
SELECT
title,
medium,
AI.GENERATE(
'Write a 1-sentence dramatic backstory for this object: ' || title || ' made of ' || medium,
endpoint => 'https://aiplatform.googleapis.com/v1/projects/<project_id>/locations/global/publishers/google/models/gemini-3-pro-preview'
) AS ai_story
FROM
`bigquery-public-data.the_met.objects`