Skip to main content

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, 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/adk-python
최근 소스 활동
2026년 10월 8일 16:56
감지된 SKILL.md 언어
영어
스타
21,870
포크
4,182

설치 방법

기본적으로 소스를 먼저 확인하는 Prompt가 선택됩니다. 직접 명령으로 전환하거나 로컬 사본을 다운로드할 수도 있습니다.

소스 파일 검토

설치 여부를 결정하기 전에 SKILL.md와 SkillsMP에 표시된 보조 파일을 읽어 보세요.

파일 탐색기
22 개 파일

SKILL.md 표시 중

SKILL.md
소스 지침 · 읽기 전용 미리보기
name
bigquery-ai-ml
license
Apache-2.0
metadata
{"author":"google-adk","version":"1.0"}
description
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.
# 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](references/ai_agg.md) - Multi-row semantic aggregation and summarization. - **AI.CAUSAL_EFFECT**: [ai_causal_effect.md](references/ai_causal_effect.md) - Quantifies the impact of an intervention on a time series. - **AI.CLASSIFY**: [ai_classify.md](references/ai_classify.md) - Classify text. - **AI.DETECT_ANOMALIES**: [ai_detect_anomalies.md](references/ai_detect_anomalies.md) - Detect anomalies. - **AI.EVALUATE**: [ai_evaluate.md](references/ai_evaluate.md) - Evaluate models. - **AI.FORECAST**: [ai_forecast.md](references/ai_forecast.md) - Time-series forecasting. - **AI.GENERATE**: [ai_generate.md](references/ai_generate.md) - Generate text using LLMs. - **AI.GENERATE_EMBEDDING**: [ai_generate_embedding.md](references/ai_generate_embedding.md) - Generate embeddings. - **AI.GENERATE_TABLE**: [ai_generate_table.md](references/ai_generate_table.md) - Table-valued AI generation. - **AI.IF**: [ai_if.md](references/ai_if.md) - Evaluate semantic conditions. - **AI.KEY_DRIVERS**: [ai_key_drivers.md](references/ai_key_drivers.md) - Identifies key drivers, this is a TVF. - **AI.SCORE**: [ai_score.md](references/ai_score.md) - Score data. - **AI.SEARCH**: [ai_search.md](references/ai_search.md) - Semantic search. - **AI.SIMILARITY**: [ai_similarity.md](references/ai_similarity.md) - Semantic similarity. - **Remote Models**: [remote_models.md](references/remote_models.md) - Working with remote models (Vertex AI). - **CONTRIBUTION_ANALYSIS**: [ml_contribution_analysis.md](references/ml_contribution_analysis.md) - Finds contributing factors, key drivers of change. Requires creating a MODEL entity. - **ML.CORRELATION**: [ml_correlation.md](references/ml_correlation.md) - Calculates correlation between columns, optionally sliced by dimensions. - **ML.DETECT_CHANGE_POINTS**: [ml_detect_change_points.md](references/ml_detect_change_points.md) - Detects structural breaks or sustained shifts in a time series. - **ML.SEASONALITY**: [ml_seasonality.md](references/ml_seasonality.md) - Extracts seasonal components from a time series. - **ML.TREND**: [ml_trend.md](references/ml_trend.md) - Extracts the long-term trend component from a time series. - **VECTOR_SEARCH**: [vector_search.md](references/vector_search.md) - Vector search best practices.
GitHub에서 보기