What it does
Snowflake Warehouse Cost Optimizer is a FinOps agent for data engineering and cost-management teams. It queries ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY and ACCOUNT_USAGE.QUERY_HISTORY to surface idle compute (4+ hours inactive) and the top 20 most expensive queries by execution_time times credits_used, then produces prioritized recommendations and estimated monthly savings (with a plus/minus 15% margin disclaimer). Output can be written to Google Sheets and posted to a Slack channel. Guardrails ensure no warehouse is ever automatically suspended — all actions require manual review, and production warehouses (prod_* prefix) are always downgraded to watch-only status. Built for data platform and FinOps teams who want automated Snowflake cost visibility instead of manually querying ACCOUNT_USAGE views.
Example prompts
- Run the full Snowflake cost analysis and post it to Slack
- Which warehouses are idle and should be auto-suspended?
- Show me the most expensive queries this month
Before you connect
The credentials this agent will ask you for — the full setup is on the Setup tab.
Needs 6 optional credentials to connect. See setup
