bigquery-ai-ml
This skill enables direct invocation of Vertex AI models within BigQuery using built-in functions like AI.FORECAST, AI.GENERATE, AI.DETECT_ANOMALIES, and AI.KEY_DRIVERS, allowing time-series forecasting, anomaly detection, key driver analysis, and content generation directly in SQL. It eliminates the need to move data or build custom ML pipelines, accelerating data analysis and AI adoption. Ideal for analysts and data scientists seeking to enrich their queries with ML without leaving the BigQuery environment.
npx skills add https://github.com/google/skills --skill bigquery-ai-mlBefore / After Comparison
1 组Users had to export data to external environments, manually train or configure ML models, then import results back. This involved switching multiple tools and often took hours or days.
This skill uses AI.FORECAST directly in BigQuery SQL, completing forecasts within minutes without leaving the data warehouse.
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
-
AI Forecast: Leveraging pre-trained TimesFM model for forecasting without custom training.
-
AI Detect Anomalies: Identify deviations in time series data using pre-trained TimesFM model.
-
AI Generate: General-purpose text and content generation using Gemini models.
-
AI Key Drivers: Automatically identify dimensional segments most responsible for driving changes in a metric.
Related Skills
- BigQuery Basics Skill: SKILL.md file for core BigQuery concepts, resource management, CLI, and client libraries.
User Reviews (0)
Write a Review
No reviews yet
Statistics
User Rating
Rate this Skill