Snowflake Efficiency Score
A free Snowflake Native App that runs a fast, secure health check on your warehouses and delivers an Efficiency Score with estimated annual savings.
Overview
The Snowflake Efficiency Score is a free Native App available on the Snowflake Marketplace. It analyzes your warehouse usage patterns and produces a single 0–100% Efficiency Score along with estimated annual savings you could unlock by optimizing your environment.
The app runs entirely inside your Snowflake account — no data ever leaves your environment. The analysis completes in under 3 minutes.
What Does the App Evaluate?
The score is built from four efficiency indicators, each mapped to a Seemore optimization capability:
Warehouse Idle Time
Compute running while no queries are executing
Auto-Shutdown
Multi-Cluster Idle Time
Extra clusters running without active workload (Enterprise+)
Auto-Scaler
Warehouse Sizing Efficiency
Whether warehouses are over- or under-sized for the workload
Smart Pulse
Clustering Column Efficiency
Effectiveness of clustering configuration and pruning
Auto-Clustering Agent
Each indicator is compared against benchmark efficiency ranges derived from real-world Snowflake usage patterns.
What You Get
After the analysis completes, the app presents:
Efficiency Score — a single benchmark score (0–100%) representing overall warehouse efficiency.
Estimated Annual Savings — a dollar estimate of potential savings based on detected inefficiencies.
Health Breakdown — per-indicator health ratings: Good, Needs Improvement, or Poor.
Optimization Details — specific warehouses and tables where inefficiencies were detected, with per-item savings estimates.
If your Snowflake account belongs to an organization with multiple accounts, the app also projects savings across the entire organization.
Prerequisites
The app requires the following privilege to run the analysis:
IMPORTED PRIVILEGES ON SNOWFLAKE DB — grants read access to
ACCOUNT_USAGEviews (warehouse events, query history, metering, clustering, and storage metrics).
This privilege is requested automatically during installation. No additional setup is needed.
Getting Started
Find the app — Search for Snowflake Efficiency Score in the Snowflake Marketplace.
Install — Click Get and follow the prompts. Grant the requested privilege when asked.
Launch — Open the app from the Apps section in Snowsight.
Run the analysis — Click I want to see my Efficiency Score and wait for the results (typically under 3 minutes).
Tip: If the app cannot automatically detect your cost-per-credit rate, you'll be asked to enter it manually on the setup screen before the analysis starts.
Support
For questions or assistance, visit seemoredata.io or contact the Seemore team directly.
Last updated