Understanding Your Score
How the Efficiency Score is calculated, what the health ratings mean, and how to interpret the savings estimate.
How the Score Is Calculated
The Efficiency Score is the average of four individual ratings, each derived from a specific efficiency indicator. Every indicator is rated independently as Good, Needs Improvement, or Poor based on the thresholds below.
Good
100
Needs Improvement
50
Poor
0
The overall Efficiency Score is the average of the four numeric values, giving you a single percentage between 0% and 100%.
Rating Thresholds
Each indicator uses a different scale depending on whether a lower or higher measured value is better.
Warehouse Idle Time
Measures the percentage of compute time spent idle (no queries running) across all warehouses over the last 21 days.
Good
< 3%
Needs Improvement
3% – 8%
Poor
> 8%
Multi-Cluster Idle Time
Measures idle time on non-primary clusters over the last 7 days. Only applicable to Enterprise edition and above.
Good
< 3%
Needs Improvement
3% – 10%
Poor
> 10%
Warehouse Sizing Efficiency
Evaluates whether your warehouses are right-sized for their workload based on query history from the last 7 days. Higher is better.
Good
≥ 80%
Needs Improvement
60% – 80%
Poor
< 60%
Clustering Column Efficiency
Measures how effectively clustering keys are configured and how well partition pruning performs over the last 7 days. Higher is better.
Good
> 90%
Needs Improvement
70% – 90%
Poor
< 70%
Estimated Annual Savings
The savings estimate is calculated per indicator and then summed to produce a total. For each indicator:
The app measures the inefficiency over the lookback window (7–21 days depending on the indicator).
Costs are attributed using your cost-per-credit rate (auto-detected from
RATE_SHEET_DAILYwhen available, or entered manually).A weighted average between a lower and upper savings bound is computed (65% weight on the lower bound, 35% on the upper).
The result is annualized by extrapolating from the lookback window to 365 days.
The savings breakdown shows how much each optimization area contributes:
Auto-Shutdown savings — eliminating idle warehouse compute
Auto-Scaler savings — reducing unnecessary multi-cluster overhead
Smart Pulse savings — right-sizing warehouses for their workloads
Clustering savings — improving or removing ineffective clustering configurations
Organization-Level Projection
If your Snowflake account is part of an organization, the app queries ORGANIZATION_USAGE.USAGE_IN_CURRENCY_DAILY to determine costs across all accounts. It then projects your account-level savings ratio across the organization to estimate the total optimization opportunity.
This projection is an estimate based on extrapolating the current account's efficiency patterns. Actual savings across accounts will vary.
Last updated