bigquery-ai-ml

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Skill: bigquery-ai-ml

Skill：bigquery-ai-ml

This skill defines the usage and rules for BigQuery AI/ML functions, preferring SQL-based Skills over dedicated BigQuery tools.

本Skill定义了BigQuery AI/ML函数的使用方法与规则，相较于专用BigQuery工具，优先选择基于SQL的Skill。

1. Skill vs Tool Preference (BigQuery AI/ML)

1. Skill与工具优先级（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.

Agents应优先使用Skill（通过
execute_sql()
执行SQL），而非专用BigQuery工具来实现预测、异常检测等功能。

请使用标准BigQuery

AI.*

函数，通过

execute_sql()

完成这些任务，而非对应的高级工具。

2. Mandatory Reference Routing

2. 强制参考路由

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/bigquery_ai_forecast.md`
AI.CLASSIFY	Categorize unstructured data into predefined labels	`references/bigquery_ai_classify.md`
AI.DETECT_ANOMALIES	Identify deviations in time-series data via the pre-trained TimesFM model	`references/bigquery_ai_detect_anomalies.md`
AI.GENERATE	General-purpose text and content generation	`references/bigquery_ai_generate.md`
AI.GENERATE_BOOL	Generate a boolean value (TRUE/FALSE) based on a prompt	`references/bigquery_ai_generate_bool.md`
AI.GENERATE_DOUBLE	Generate a floating-point number based on a prompt	`references/bigquery_ai_generate_double.md`
AI.GENERATE_INT	Generate an integer value based on a prompt	`references/bigquery_ai_generate_int.md`
AI.IF	Evaluate a natural-language boolean condition	`references/bigquery_ai_if.md`
AI.SCORE	Rank items by semantic relevance (use with ORDER BY)	`references/bigquery_ai_score.md`
AI.SIMILARITY	Compute cosine similarity between two inputs	`references/bigquery_ai_similarity.md`
AI.SEARCH	Semantic search on tables with autonomous embedding generation	`references/bigquery_ai_search.md`

本Skill文件不包含这些函数的语法。在生成SQL之前，你必须阅读相关参考文件。

重要提示：请勿猜测文件名。你只能使用以下提供的准确路径。

函数	描述	需获取的参考文件
AI.FORECAST	通过预训练TimesFM模型进行时间序列预测	`references/bigquery_ai_forecast.md`
AI.CLASSIFY	将非结构化数据分类到预定义标签中	`references/bigquery_ai_classify.md`
AI.DETECT_ANOMALIES	通过预训练TimesFM模型识别时间序列数据中的偏差	`references/bigquery_ai_detect_anomalies.md`
AI.GENERATE	通用文本与内容生成	`references/bigquery_ai_generate.md`
AI.GENERATE_BOOL	根据提示生成布尔值（TRUE/FALSE）	`references/bigquery_ai_generate_bool.md`
AI.GENERATE_DOUBLE	根据提示生成浮点数	`references/bigquery_ai_generate_double.md`
AI.GENERATE_INT	根据提示生成整数	`references/bigquery_ai_generate_int.md`
AI.IF	评估自然语言布尔条件	`references/bigquery_ai_if.md`
AI.SCORE	按语义相关性对项目排名（搭配ORDER BY使用）	`references/bigquery_ai_score.md`
AI.SIMILARITY	计算两个输入之间的余弦相似度	`references/bigquery_ai_similarity.md`
AI.SEARCH	对表格进行语义搜索并自动生成嵌入向量	`references/bigquery_ai_search.md`