Index of every page on this site: llms.txt
All skills
google avatar

/bigquery-ai-ml

@37de74d
by googlegoogle/adk-python22k stars
4,392
Run it yourself

Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics. Use when you need to write SQL queries that perform time-series forecasting, predict values, detect outliers or anomalies, find key drivers, perform semantic search or vector search, classify text, calculate similarity, summarize content, translate language, evaluate models, filter by semantic conditions, measure the causal effect of an intervention, compute correlations between columns, detect change points or structural breaks, extract trend or seasonality components, or leverage generative AI capabilities in BigQuery. Do not use for general BigQuery dataset, table, or job management requests.

Use this Skill: https://skilld.dev/gh/google/adk-python/bigquery-ai-ml

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

referencesai_generate.md

≈1k tokens on demand. Your agent reads this file only when SKILL.md points to it.

BigQuery AI.Generate

AI.GENERATE is a general-purpose function text and content generation.

Syntax Reference

AI.GENERATE(
  [ prompt => ] 'PROMPT',
  [, endpoint => 'ENDPOINT']
  [, model_params => 'MODEL_PARAMS']
  [, output_schema => 'OUTPUT_SCHEMA']
  [, connection_id => 'CONNECTION_ID']
  [, request_type => 'REQUEST_TYPE']
)

Input Arguments

Argument Requirement Type Description
prompt Required String The prompt text or
: : : : instruction for the :
: : : : model. :
connection_id Optional String The connection ID.
: : : : Optional if :
: : : : configured via other :
: : : : means or testing. :
endpoint Optional String The model name, e.g.,
: : : : 'gemini-2.5-flash'. :
output_schema Optional String Schema definition for
: : : : structured output, :
: : : : e.g., `'answer BOOL, :
: : : : reason STRING'`. :
request_type Optional String 'DEDICATED' or
: : : : 'SHARED'. :
model_params Optional JSON JSON object for model
: : : : parameters (e.g., :
: : : : temperature, :
: : : : max_output_tokens). :

Output Schema

Returns a STRUCT with the following fields:

Column Name Type Description
result STRING (or Custom) The generated content. If
: : : output_schema is used, this :
: : : field is replaced by the :
: : : schema's fields. :
status STRING API response status (empty on
: : : success). :
full_response JSON The complete raw JSON response
: : : from the model (including :
: : : safety ratings, usage :
: : : metadata). :

Examples

Basic Text Generation

SELECT
  AI.GENERATE(
    'Summarize this article: ' || article_content,
    connection_id => 'my-project.us.my-connection',
    endpoint => 'gemini-2.5-flash'
  ) as summary
FROM `dataset.articles`
LIMIT 5;

Structured Output Generation

SELECT
  AI.GENERATE(
    'Extract the date and amount from this invoice: ' || invoice_text,
    output_schema => 'date DATE, amount FLOAT64'
  ) as extracted_data
FROM `dataset.invoices`;

Process images in a Cloud Storage bucket

CREATE SCHEMA IF NOT EXISTS bqml_tutorial;

CREATE OR REPLACE EXTERNAL TABLE bqml_tutorial.product_images
  WITH CONNECTION DEFAULT OPTIONS (
    object_metadata = 'SIMPLE',
    uris = ['gs://cloud-samples-data/bigquery/tutorials/cymbal-pets/images/*.png']);

SELECT
  uri,
  STRING(OBJ.GET_ACCESS_URL(ref,'r').access_urls.read_url) AS signed_url,
  AI.GENERATE(
    ("What is this: ", OBJ.GET_ACCESS_URL(ref, 'r')),
    output_schema =>
      "image_description STRING, entities_in_the_image ARRAY<STRING>").*
FROM bqml_tutorial.product_images
WHERE uri LIKE "%aquarium%";

Source: SKILL.md on GitHub

No rule matched.

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No alerts5mo3 checks · Risk SAFE
  • Gen Agent Trust Hub5mo

    This skill provides a comprehensive interface for BigQuery AI and Machine Learning functions using standard SQL. It includes security considerations regarding the handling of untrusted data within AI-driven queries, which is standard for this type of functionality. Users should apply appropriate data validation when using these features.

  • Socket5mo

    No alerts

  • Snyk5mo

    Risk: LOW · No issues

Signed by skilld at 37de74d. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub yesterday.

Activeupdated last month
metadata
{
  "author": "google-adk",
  "version": "1.0"
}

README badge

README badge for google/adk-python/bigquery-ai-ml