bigquery-ai-ml
此技能在 BigQuery 中通过内置函数(如 AI.FORECAST、AI.GENERATE)直接调用 Vertex AI 模型,实现时间序列预测、异常检测、关键驱动因素分析和文本生成。用户无需移动数据或编写复杂代码,即可在 SQL 工作流中快速集成机器学习与生成式 AI,大幅提升数据分析效率。
npx skills add https://github.com/google/skills --skill bigquery-ai-mlBefore / After 效果对比
1 组用户需要导出数据到外部环境,手动训练或配置机器学习模型,再导回结果。整个过程涉及多个工具切换,通常需要数小时甚至数天。
此技能直接在 BigQuery 中使用 AI.FORECAST 函数,在 SQL 查询中完成预测,几分钟内获得结果,无需离开数据仓库。
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.
用户评价 (0)
发表评价
暂无评价
统计数据
用户评分
为此 Skill 评分