# Snowflake Efficiency Score

## Overview

The **Snowflake Efficiency Score** is a free Native App available on the [Snowflake Marketplace](https://app.snowflake.com/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:

| Indicator                        | What It Measures                                             | Related Seemore Feature |
| -------------------------------- | ------------------------------------------------------------ | ----------------------- |
| **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:

1. **Efficiency Score** — a single benchmark score (0–100%) representing overall warehouse efficiency.
2. **Estimated Annual Savings** — a dollar estimate of potential savings based on detected inefficiencies.
3. **Health Breakdown** — per-indicator health ratings: **Good**, **Needs Improvement**, or **Poor**.
4. **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_USAGE` views (warehouse events, query history, metering, clustering, and storage metrics).

This privilege is requested automatically during installation. No additional setup is needed.

***

## Getting Started

1. **Find the app** — Search for *Snowflake Efficiency Score* in the [Snowflake Marketplace](https://app.snowflake.com/marketplace).
2. **Install** — Click **Get** and follow the prompts. Grant the requested privilege when asked.
3. **Launch** — Open the app from the **Apps** section in Snowsight.
4. **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](https://www.seemoredata.io) or contact the Seemore team directly.