By name: ai-cost-dashboard description: "Build and manage a Snowflake AI Cost Dashboard using stored procedures and Streamlit. Use for ALL requests involving: AI cost, AI spending, cost dashboard, spending dashboard, Snowflake AI credits, Cortex cost tracking. DO NOT attempt AI cost dashboard work manually - invoke this skill first."
AI Cost Dashboard
Deploys and manages a Cortex AI Cost Dashboard tracking credit usage across Snowflake AI services via stored procedures and a Streamlit app.
Source Files
- Setup SQL:
cortex_ai_cost_dashboard/setup.sql(template — uses{{WAREHOUSE}}placeholder) - Streamlit App:
cortex_ai_cost_dashboard/streamlit_app.py(dynamic — derives DB/schema from session context) - Semantic Model:
cortex_ai_cost_dashboard/cortex_ai_costs_model.yaml(template — uses{{DATABASE}}/{{SCHEMA}}placeholders) - Snowflake CLI config:
cortex_ai_cost_dashboard/snowflake.yml(template — uses{{DATABASE}}/{{SCHEMA}}/{{WAREHOUSE}}placeholders) - Deploy Skill:
cortex_ai_cost_dashboard/skills/ai-cost-dashboard-deploy/SKILL.md
Architecture
SNOWFLAKE.ACCOUNT_USAGE (usage history views)
-> MERGE (incremental)
<DATABASE>.<SCHEMA> (detail tables + unified + user-level)
-> Queried by
Streamlit App (CORTEX_AI_COST_DASHBOARD)
All object names (database, schema, warehouse, role, credit rate) are configurable at deploy time.
Key objects (created in user-specified database.schema):
- Procedures:
REFRESH_CORTEX_AI_COSTS(DAYS_BACK),REFRESH_USER_AI_COSTS(DAYS_BACK) - Tables:
CORTEX_AI_UNIFIED_COSTS,USER_AI_COSTS, plus detail tables - Task:
REFRESH_CORTEX_AI_COSTS_DAILY(CRON 0 6 * * * UTC)
Configurable Parameters
| Parameter | Description | Default |
|---|---|---|
| Connection | Snowflake CLI connection name | — |
| Database | Target database | ADMIN_DB |
| Schema | Target schema | AI_COSTS |
| Warehouse | Warehouse for queries and tasks | COMPUTE_WH |
| Role | Deployment role | ACCOUNTADMIN |
| Credit Rate | Current standard $/credit rate | 2.88 |
| Historical Rate | Previous $/credit rate (before current) | 3.01 |
Intent Detection
| Intent | Triggers | Load |
|---|---|---|
| SETUP | "set up", "deploy", "create", "install", "build dashboard" | setup-deploy/SKILL.md |
| ANALYZE | "analyze", "report", "show costs", "insights", "spending breakdown" | analyze-report/SKILL.md |
Workflow
Step 1: Identify Intent
Ask the user what they want to do:
What would you like to do with the AI Cost Dashboard?
1. Setup / Deploy - Deploy stored procedures and Streamlit app from scratch
2. Analyze / Report - Analyze current AI cost data and generate insights
Route based on selection:
- Option 1 -> Load
setup-deploy/SKILL.md - Option 2 -> Load
analyze-report/SKILL.md
If intent is clear from context, skip the question and route directly.
Prerequisites
- Snowflake account with ACCOUNTADMIN or role with ACCOUNT_USAGE access
- Warehouse for query execution
Output
Deployed AI cost dashboard or cost analysis report depending on intent.