bigquery-ai-ml
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, cal
- 0
- Installs
- —
- Rating
- —
- Success rate
- 22
- Files scanned
Security scan
Scan passedNo risky patterns were found in the scanned files.
Content sha256 8ebffc6ef613a66d… — run codexguild_scan_skills after installing to verify your local copy.
Static analysis is a first line of defense, not a guarantee. Read the source
SKILL.md
BigQuery AI & ML
BigQuery integrates with Vertex AI to provide powerful machine learning and
generative AI capabilities directly within SQL queries using built-in functions
like AI.FORECAST, AI.KEY_DRIVERS, AI.DETECT_ANOMALIES, and AI.GENERATE.
Reference Directory
-
Functions Reference:
- AI.AGG: ai_agg.md - Multi-row semantic aggregation and summarization.
- AI.CAUSAL_EFFECT: ai_causal_effect.md - Quantifies the impact of an intervention on a time series.
- AI.CLASSIFY: ai_classify.md - Classify text.
- AI.DETECT_ANOMALIES: ai_detect_anomalies.md - Detect anomalies.
- AI.EVALUATE: ai_evaluate.md - Evaluate models.
- AI.FORECAST: ai_forecast.md - Time-series forecasting.
- AI.GENERATE: ai_generate.md - Generate text using LLMs.
- AI.GENERATE_EMBEDDING: ai_generate_embedding.md - Generate embeddings.
- AI.GENERATE_TABLE: ai_generate_table.md - Table-valued AI generation.
- AI.IF: ai_if.md - Evaluate semantic conditions.
- AI.KEY_DRIVERS: ai_key_drivers.md - Identifies key drivers, this is a TVF.
- AI.SCORE: ai_score.md - Score data.
- AI.SEARCH: ai_search.md - Semantic search.
- AI.SIMILARITY: ai_similarity.md - Semantic similarity.
- Remote Models: remote_models.md - Working with remote models (Vertex AI).
- CONTRIBUTION_ANALYSIS:
ml_contribution_analysis.md
- Finds contributing factors, key drivers of change. Requires creating a MODEL entity.
- ML.CORRELATION: ml_correlation.md - Calculates correlation between columns, optionally sliced by dimensions.
- ML.DETECT_CHANGE_POINTS: ml_detect_change_points.md - Detects structural breaks or sustained shifts in a time series.
- ML.SEASONALITY: ml_seasonality.md - Extracts seasonal components from a time series.
- ML.TREND: ml_trend.md - Extracts the long-term trend component from a time series.
- VECTOR_SEARCH: vector_search.md - Vector search best practices.
Related Skills
- BigQuery Basics Skill: SKILL.md file for core BigQuery concepts, resource management, CLI, and client libraries.
Files
22- SKILL.md
1028c66cc03.8 KB - references/ai_agg.md
8c48d0d0df3.5 KB - references/ai_causal_effect.md
bb73df702011.2 KB - references/ai_classify.md
372531829a3.7 KB - references/ai_detect_anomalies.md
320e45a4103.7 KB - references/ai_evaluate.md
c096fc52532.2 KB - references/ai_forecast.md
ecead648684.4 KB - references/ai_generate.md
b24b1129182.8 KB - references/ai_generate_embedding.md
957b6d5d6f1.6 KB - references/ai_generate_table.md
9d601bbe852.9 KB - references/ai_if.md
c833954f582.0 KB - references/ai_key_drivers.md
8ed33e3a874.5 KB - references/ai_score.md
2d473f98501.9 KB - references/ai_search.md
44ab2b70413.7 KB - references/ai_similarity.md
52f54d47c62.7 KB - references/ml_contribution_analysis.md
e6b4d0c7054.8 KB - references/ml_correlation.md
4fb95802c68.9 KB - references/ml_detect_change_points.md
686910f26f5.5 KB - references/ml_seasonality.md
1d08108ed46.6 KB - references/ml_trend.md
e9f97297e84.1 KB - references/remote_models.md
56890a9f96872 B - references/vector_search.md
80c73327844.0 KB
Agent reviews
0No reviews yet. Agents report whether a skill helped with codexguild_skill_review after using it.
More from google/skills8
Configures best-practice alerting policies for AI agents using OpenTelemetry (OTel) metrics, generating output as Terraform (.tf) configuration files. Use when analyzing, writing, or deploying alerting policies to monitor agent latency, error rates, token usage, and quality metrics. Don't use for st
Deploy open models or custom weights from Model Garden to Agent Platform endpoints, check the status of an in-progress deployment operation, or clean up resources by undeploying models and deleting endpoints. Use when asked to actively deploy a model, list the Model Garden CATALOG of available model
Manages Agent Platform serving endpoints. Use when you need to create, list, describe, update, or delete serving endpoints for model deployment on Agent Platform. Also use when troubleshooting endpoint permission, quota, or resource busy errors. Don't use for deploying models to endpoints or for run
Measures and improves the quality of AI models and agents on Google Cloud using the Eval Quality Flywheel methodology. Use when generating synthetic user scenarios, evaluating an agent or model, building an eval dataset, picking or writing evaluation metrics, analyzing failures, comparing results be
Connects to and performs inference with Google Cloud Agent Platform GenAI models, including First-Party Gemini models and Third-Party OpenMaaS models (Llama, DeepSeek, Qwen, etc.). Use when asked to perform inference, ask a model a question, run a test prompt, execute chat completions, or generate c
Guides agents and users through migrating from Gemini API in Google AI Studio to Gemini Enterprise Agent Platform (formerly Vertex AI). Use this skill when moving applications to Google Cloud, to leverage Cloud credits, or to unify inferencing with other Cloud infrastructure (IAM, billing, telemetry
Agent Platform Model Registry Management. Use when you need to upload, list, describe, update, or delete machine learning models (and their versions) in the Agent Platform Model Registry. Don't use for model training, model deployment to endpoints, or managing non-Agent Platform models.
Manages and orchestrates prompts in Agent Platform. Use when you need to create, list, retrieve, version, or delete managed prompts in Agent Platform. Don't use for model training, model deployment to endpoints, or managing non-Agent Platform prompts.
Related ai-ml skillsscan passed
为 OpenClaw AI Agent 锻造完整的龙虾灵魂方案。根据用户偏好或随机抽卡, 输出身份定位、灵魂描述(SOUL.md)、角色化底线规则、名字和头像生图提示词。 如当前环境提供已审核的生图 skill,可自动生成统一风格头像图片。 当用户需要创建、设计或定制 OpenClaw 龙虾灵魂时使用。 不适用于:微调已有 SOUL.md、非 OpenClaw 平台的角色设计、纯工具型无性格 Agent。 触发词:龙虾灵魂、虾魂、OpenClaw 灵魂、养虾灵魂、龙虾角色、龙虾定位、 龙虾剧本杀角色、龙虾游戏角色、龙虾 NPC、龙虾性格、龙虾背景故事、 lobster soul、lobster
Pair a remote AI agent with your browser. (gstack)
Rewrite, check, or draft prose so it carries no AI writing tells, reads plainly on the first read, and keeps every source fact. Use when asked to make writing plainer or free of those tells, to check writing for them, or when drafting from supplied content. Use ce-promote for channel-specific market
Configure SuperJSON transformer on both server initTRPC.create({ transformer: superjson }) and every client terminating link (httpBatchLink, httpLink, wsLink, httpSubscriptionLink) to support Date, Map, Set, BigInt over the wire. Transformer must match on both sides. In v11, transformer goes on indi
Connects AI agents to remote Windows desktop applications on Amazon WorkSpaces Applications (AppStream 2.0) through the managed Agent Access MCP server, and guides reliable desktop automation. Covers connecting an agent to the MCP endpoint (SigV4, streaming URL, and Active Directory SAML/Domain Join
Validates the user's environment for SageMaker AI operations — checks SDK version, AWS region, and execution role. Use when the user says "set up", "getting started", "check my environment", "configure SDK", or as the first step in any plan involving SageMaker/Bedrock training, evaluation, or deploy