FreeRead-onlySnowflake Native App

Tabby Cost Optimizer: cut Snowflake costs with automated, read-only analysis

A free Snowflake Native App that finds where your spend is going and what to do about it. It reads your ACCOUNT_USAGE data inside your own account, computes cost and right-sizing recommendations, and hands you the exact SQL to act on them. It never modifies your resources.

What it analyzes

Five analysis domains, each with concrete recommendations and the SQL to apply them.

Warehouses

Right-sizing recommendations, auto-suspend tuning, and idle time detection for every warehouse in your account.

Storage

Unused tables sorted by storage cost, clustering opportunities, and time-travel retention review.

Workloads

Query patterns by day and hour, query anti-patterns, and serverless credit consumption per service.

Governance

Month-to-date spend per usage group or team, plus resource monitor coverage and thresholds.

Insights

A cross-domain, prioritized list of your biggest savings opportunities, each with copy-paste SQL to act on it.

Why it is safe

Built for security review. Nothing leaves your account.

Runs in your account

The app runs entirely inside your Snowflake account on Snowpark Container Services. No data leaves your account.

Read-only

It reads ACCOUNT_USAGE system views and nothing else. It never modifies your warehouses, tables, or configuration.

No outbound network calls

The container makes no external requests. Recommendations are computed locally against your usage data.

No credentials collected

There is nothing to sign up for and no account to create. Install, grant privileges, open the dashboard.

Getting started

Four steps from install to your first savings recommendation.

  1. 1

    Install from the Snowflake Marketplace

    Get the app from the Snowflake Marketplace listing. Installation is free.

  2. 2

    Grant the four privileges

    When you open the app, Snowsight prompts for the privileges it needs to run:

    • Create compute pool: runs the optimizer service
    • Create warehouse: an X-Small warehouse to query ACCOUNT_USAGE
    • Bind service endpoint: exposes the web UI
    • Imported privileges on the SNOWFLAKE database: read-only ACCOUNT_USAGE access
  3. 3

    Grant read access to account usage

    Run this one statement as ACCOUNTADMIN so the app can read your usage data:

    GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO APPLICATION TABBY_COST_OPTIMIZER;
  4. 4

    Start the service and open the dashboard

    On the launcher console, click Start optimizer. First launch takes 1-2 minutes while the container service provisions. Then click Open Cost Optimizer to load the dashboard.

Running cost

The app itself is free. It runs one X-Small compute pool node and an X-Small warehouse in your account, both with auto-suspend. Use Stop service on the console when you are not analyzing.

Uninstall

Remove the app and everything it created with one statement:

DROP APPLICATION TABBY_COST_OPTIMIZER;

Inside the dashboard

Ten pages across five sections, from a spend overview down to per-table detail.

Overview

  • Home: KPI cards, daily spend trend, top opportunities, anomalies

Optimization

  • Warehouses: Right-sizing recommendations per warehouse
  • Storage: Storage category breakdown and top tables
  • Clustering: Tables with degraded clustering
  • Unused tables: Unused tables sorted by storage cost

Workloads

  • Query patterns: Day-of-week by hour heatmap and top queries
  • Serverless: Credit consumption per serverless service

Governance

  • Usage groups: Month-to-date spend per usage group or team
  • Resource monitors: Monitor coverage and thresholds

Configuration

  • Settings: Pricing config, thresholds, refresh, connection info

Pricing

Free

No license fee, no tiers, no trial clock. You pay only the Snowflake compute the app uses in your own account.

Support and legal

See where your Snowflake spend is going

Install free from the Snowflake Marketplace. Want hands-on help instead? Our team runs full cost optimization engagements.