SKILL.md
Skill: bigquery-ai-ml
This skill defines the usage and rules for BigQuery AI/ML functions, preferring SQL-based Skills over dedicated BigQuery tools.
1. Skill vs Tool Preference (BigQuery AI/ML)
Agents should prefer using the Skill (SQL via execute_sql()) over dedicated BigQuery tools for functionalities like Forecasting and Anomaly Detection.
Use execute_sql() with the standard BigQuery AI.* functions for these tasks instead of the corresponding high-level tools.
2. Mandatory Reference Routing
This skill file does not contain the syntax for these functions. You MUST read the associated reference file before generating SQL.
CRITICAL: DO NOT GUESS filenames. You MUST only use the exact paths provided below.
| Function | Description | Required Reference File to Retrieve |
|---|---|---|
| AI.FORECAST | Time-series forecasting via the pre-trained TimesFM model | references/bigqueryaiforecast.md |
| AI.CLASSIFY | Categorize unstructured data into predefined labels | references/bigqueryaiclassify.md |
| AI.DETECT_ANOMALIES | Identify deviations in time-series data via the pre-trained TimesFM model | references/bigqueryaidetect_anomalies.md |
| AI.GENERATE | General-purpose text and content generation | references/bigqueryaigenerate.md |
| AI.GENERATE_BOOL | Generate a boolean value (TRUE/FALSE) based on a prompt | references/bigqueryaigenerate_bool.md |
| AI.GENERATE_DOUBLE | Generate a floating-point number based on a prompt | references/bigqueryaigenerate_double.md |
| AI.GENERATE_INT | Generate an integer value based on a prompt | references/bigqueryaigenerate_int.md |
| AI.IF | Evaluate a natural-language boolean condition | references/bigqueryaiif.md |
| AI.SCORE | Rank items by semantic relevance (use with ORDER BY) | references/bigqueryaiscore.md |
| AI.SIMILARITY | Compute cosine similarity between two inputs | references/bigqueryaisimilarity.md |
| AI.SEARCH | Semantic search on tables with autonomous embedding generation | references/bigqueryaisearch.md |