1

    snowflake-auditor

    by Ikerg

    Audit Snowflake config and SQL against 2026 pricing to find waste and generate instant-fix ALTER statements.

    Updated Jun 2026
    Security scanned

    $29

    · or 145 credits

    30-day refund guarantee

    Secure checkout via Stripe

    Included in download

    • Right-size warehouses based on actual credit consumption and spilling metrics.
    • Convert permanent staging tables to transient to eliminate Fail-safe costs.
    • terminal automation included
    • Instant install

    Sample input

    Audit my warehouse configuration and this staging table SQL for potential cost savings.

    Sample output

    Top Findings

    1. W001: Auto-suspend (PROD_WH)

      • [!] Current: 600s | Recommended: 60s
      • Est. Savings: $420/mo (Assumes 5 resumes/day)
      • Fix: ALTER WAREHOUSE PROD_WH SET AUTO_SUSPEND = 60;

    2. ST021: Permanent Staging Table

      • [!] High churn table should be TRANSIENT to avoid Fail-safe.
      • Est. Savings: $85/mo storage tax.

    About This Skill

    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.

    Use Cases

    • Right-size warehouses based on actual credit consumption and spilling metrics.
    • Convert permanent staging tables to transient to eliminate Fail-safe costs.
    • Identify SQL anti-patterns in pipelines that cause unnecessary partition scans.
    • Migrate over-scheduled tasks to serverless to bypass warehouse resume minimums.

    Reviews

    No reviews yet - be the first to share your experience.

    Only users who have downloaded or purchased this skill can leave a review.

    Security Scanned

    Passed automated security review

    Permissions

    Terminal / Shell

    Allowed Hosts

    keepachangelog.com
    docs.snowflake.com
    www.snowflake.com

    File Scopes

    data/**
    references/**
    scripts/**
    examples/**
    evals/**

    Tags

    snowflake
    finops
    sql-optimization
    cloud-cost
    data-engineering

    Creator

    Ikerg

    Lead Data Engineer with 11 years of experience designing and delivering scalable data platforms across Databricks, AWS, and Azure ecosystems. Proven track record of building high-performance data solutions for large-scale, data-intensive organizations in industries including healthcare and robotics. Extensive experience working in highly regulated environments, managing complex data pipelines and large volumes of structured and unstructured data.

    Frequently Asked Questions

    Learn More About AI Agent Skills

    More Premium Skills

    designing-hybrid-context-layers

    Architects the right retrieval strategy for every query — teaching your agent when to use RAG, a knowledge graph, or a temporal index instead of defaulting to vector search for everything.

    $1015 installs

    consumer-motivation-analyzer

    Go beyond surface-level feedback to uncover the psychological drivers and hidden motivations behind buyer behavior.

    $199 installs

    Bounty Security Pattern Master Library — 399 Vulnerability Patterns

    A premium library of 399 vulnerability patterns and DeFi attack vectors for AI-driven bug hunting and security audits.

    $758 installs

    ai-automation-qa-pack

    Professional QA & UAT documentation generator for AI automation agencies and complex agent deployments.

    $58 installs