grok-bot:LI4x0WdC_saRljwVwno4X
Snowflake Analyst
只读的 Snowflake 分析师:用大白话问数仓问题,它写出并展示 SQL,每个数字都标明来源查询,还会检查成本
简介
只读的 Snowflake 分析师:用大白话问数仓问题,它写出并展示 SQL,每个数字都标明来源查询,还会检查成本
包含内容
- skill getting-started Use for a read-only Snowflake analyst bot's first conversation with a new owner: connect Snowflake's managed MCP server with a read-only role, learn which data matters, and offer the weekly health report.
- skill snowflake-mcp-server-setup Use when a new owner needs to create a Snowflake-managed MCP server, a read-only role, and a PAT so the analyst bot can query their warehouse, or when that connection fails.
- skill warehouse-health-report Use when running the weekly Snowflake warehouse health report: credits by warehouse, stale tables, failed loads, and failed tasks over the last 7 days, read-only.
- skill table-profile Use when asked to profile, audit, or deeply understand a Snowflake table (or a set of tables): structure, size, column-level quality and distributions, keys, relationships, freshness, and analyst-ready findings, read-only.
- skill question-to-sql Use for any ad-hoc business question that needs a number from Snowflake: finds the right tables, states grain and assumptions, writes the SQL, and validates joins, filters, nulls, and a cross-check before answering, read-only.
- skill metric-deep-dive Use when asked why a metric went up or down between two periods: checks data issues first, then splits the change by dimension and into rate vs mix, read-only.
- skill cohort-retention Use when asked about retention, churn, repeat behavior, or lifetime value by signup or first-purchase cohort: builds a cohort retention matrix, repeat rates, and cumulative value per member, read-only.
- skill experiment-readout Use to read out an A/B test from assignment and outcome tables: sample ratio mismatch check, conversion and mean lifts with 95% CIs and p-values computed in SQL, guardrails, and caveats, read-only.
- skill query-cost-review Use when asked which queries are slow or expensive, why warehouse spend rose, or how to tune: reviews ACCOUNT_USAGE query history and suggests fixes in plain English, read-only.
- skill data-quality-monitor Use to check key tables for freshness, volume swings, null keys, duplicate keys, and orphaned foreign keys with PASS/WARN/FAIL per check; built for a weekly routine that alerts only on WARN or FAIL, read-only.
- memory Memory entries · 7 项
- plugin Plugin references · 1 项
依赖
- 必需 Snowflake 653
附件
此记录没有单独发布的附件。