Snowflake Cost & Performance Auditor

The Snowflake Auditor is a developer-centric tool designed to eliminate waste and optimize performance within Snowflake environments. Instead of relying on AI-generated "best guesses," it utilizes a deterministic rule engine mapped against real-world 2026 pricing data to identify specific misconfigurations and SQL anti-patterns that drive up cloud bills.

What it does

Warehouse Right-sizing: Detects oversized warehouses, long auto-suspend settings, and inefficient multi-cluster configurations.
Storage Optimization: Identifies unnecessary Time Travel retention and Fail-safe "taxes" on transient staging tables.
Task & Serverless Guardrails: Flags over-scheduled tasks and identifies candidates for serverless execution to avoid the 60s resume minimum.
SQL Static Analysis: Scans pipelines for high-cost patterns like Cartesian joins, non-sargable predicates, and unnecessary clustering churn.

Why use this skill?

Prompting a generic AI for Snowflake advice often results in high-level best practices. This skill provides a quantified audit. For every finding, it calculates an estimated $/month saving based on your Snowflake edition and region, providing the exact ALTER statements needed to implement the fix. It bridges the gap between FinOps theory and engineering execution.

Supported Audit Areas

Compute: Warehouses, Resource Monitors, and Statement Timeouts.
Storage: Retention policies, Clones, and Cold Table identification.
Serverless: Auto-clustering, Materialized Views, and Search Optimization Service.
Code: SQL Pipeleines, DDL, and DML anti-patterns.