跳到正文
cccskills
免费在 GitHub 公开

bigquery-ai-ml

Write SQL that uses BigQuery’s built-in machine learning and generative AI for forecasting, anomaly detection, identifying drivers of change, searching by meaning, and classifying or summarizing text stored in your data.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

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.

集成工具Google Cloud
查看安装方法

适用场景

  • Forecasting future values from time-series data
  • Detecting anomalies and investigating drivers of change
  • Searching documents by meaning
  • Classifying and summarizing text in tables
  • Measuring the impact of an intervention

包含的文件(22)

  • SKILL.md3.8 KB
  • references/ai_agg.md3.5 KB
  • references/ai_causal_effect.md11.2 KB
  • references/ai_classify.md3.7 KB
  • references/ai_detect_anomalies.md3.7 KB
  • references/ai_evaluate.md2.2 KB
  • references/ai_forecast.md4.4 KB
  • references/ai_generate_embedding.md1.6 KB
  • references/ai_generate_table.md2.9 KB
  • references/ai_generate.md2.8 KB
  • references/ai_if.md2.0 KB
  • references/ai_key_drivers.md4.5 KB
  • references/ai_score.md1.9 KB
  • references/ai_search.md3.7 KB
  • references/ai_similarity.md2.7 KB
  • references/ml_contribution_analysis.md4.8 KB
  • references/ml_correlation.md8.9 KB
  • references/ml_detect_change_points.md5.5 KB
  • references/ml_seasonality.md6.6 KB
  • references/ml_trend.md4.1 KB
  • references/remote_models.md872 B
  • references/vector_search.md4.0 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

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

Related Skills

  • BigQuery Basics Skill: SKILL.md file for core BigQuery concepts, resource management, CLI, and client libraries.

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Create Terraform files that define alerts for AI agent latency, errors, token use, safety, security, and response quality. Check telemetry and existing policies first, then validate the generated configuration. Quality alerts require Vertex AI.

中文简介正在准备中。当前显示英语简介。

  • Configure alerts for agent latency and error rates
  • Monitor rapid increases in token usage
  • Monitor safety triggers and permission denials
google/skills2.1万2026年10月20日 更新

Deploy Model Garden models to Agent Platform endpoints, the addresses used for model requests. Check supported hardware and estimated hourly costs, inspect deployment progress, test predictions, and remove deployed resources after use.

中文简介正在准备中。当前显示英语简介。

  • Choose a deployable model and supported hardware
  • Estimate hourly deployment costs before approval
  • Check deployment progress and test predictions
google/skills2.1万2026年10月20日 更新

Manages Agent Platform endpoints, the stable URLs used to serve online model predictions. It supports listing, inspecting, creating, updating, and deleting endpoints, plus troubleshooting permission errors, quota limits, and resources that are busy.

中文简介正在准备中。当前显示英语简介。

  • Listing endpoints and checking their configuration
  • Creating an endpoint before model deployment
  • Updating endpoint display names or labels
google/skills2.1万2026年10月20日 更新

Evaluate AI models and agents on Google Cloud using test datasets and scoring criteria. Generate simulated user scenarios, analyze failures, and compare results across changes to guide improvements to prompts and code.

中文简介正在准备中。当前显示英语简介。

  • Build evaluation datasets from conversation logs
  • Generate simulated user scenarios
  • Choose scoring criteria for responses and tool use
google/skills2.1万2026年10月20日 更新

Call Gemini and OpenMaaS models such as Llama, DeepSeek, and Qwen through Google Cloud Agent Platform. Prepare authentication and SDK code, run prompts, configure connection endpoints, and troubleshoot common request errors.

中文简介正在准备中。当前显示英语简介。

  • Send a test prompt to Gemini
  • Call Llama or DeepSeek with the OpenAI SDK
  • Write code to call an existing custom endpoint
google/skills2.1万2026年10月20日 更新

Guides migration from Google AI Studio’s Gemini API to Gemini Enterprise Agent Platform on Google Cloud, covering billing, access permissions, authentication, and connection settings for SDKs and supported agent tools.

中文简介正在准备中。当前显示英语简介。

  • Moving a Gemini application to Google Cloud
  • Using Google Cloud credits for Gemini API calls
  • Unifying agent authentication and billing
google/skills2.1万2026年10月20日 更新

查看 google 的全部技能

报告此技能的问题