# Installation

## Step 1 — Find the App on Snowflake Marketplace

1. Log in to your Snowflake account via [Snowsight](https://app.snowflake.com).
2. Navigate to **Marketplace** in the left sidebar.
3. Search for **Snowflake Efficiency Score** (by SeemoreData).

***

## Step 2 — Install the App

1. Click **Get** on the app listing page.
2. Accept the terms and conditions.
3. Choose the warehouse and role to use for installation (defaults are fine for most environments).
4. Click **Install**.

The app will be installed as a Native App in your account.

***

## Step 3 — Grant Required Privileges

After installation, the app requests one privilege:

* **IMPORTED PRIVILEGES ON SNOWFLAKE DB** — allows read-only access to `ACCOUNT_USAGE` views for the analysis.

Click **Grant** when prompted. The app uses the following views:

| View                           | Purpose                                      |
| ------------------------------ | -------------------------------------------- |
| `WAREHOUSE_EVENTS_HISTORY`     | Detect idle time between queries             |
| `QUERY_HISTORY`                | Analyze query execution and warehouse sizing |
| `WAREHOUSE_METERING_HISTORY`   | Calculate credit consumption                 |
| `AUTOMATIC_CLUSTERING_HISTORY` | Evaluate clustering costs                    |
| `TABLE_PRUNING_HISTORY`        | Measure partition pruning effectiveness      |
| `TABLE_STORAGE_METRICS`        | Assess table sizes for clustering analysis   |

For organization-level projections, the app also reads from:

| View                      | Purpose                                      |
| ------------------------- | -------------------------------------------- |
| `RATE_SHEET_DAILY`        | Auto-detect cost-per-credit rate             |
| `USAGE_IN_CURRENCY_DAILY` | Project savings across organization accounts |

> **Note:** Access to organization views is optional. If unavailable, the app will ask you to enter your cost-per-credit rate manually and will skip the organization projection.

***

## Step 4 — Launch the App

1. Go to **Apps** in the Snowsight left sidebar.
2. Find **Snowflake Efficiency Score** in your installed apps.
3. Click to open it.

***

## Step 5 — Run the Analysis

1. On the welcome screen, click **I want to see my Efficiency Score**.
2. If prompted, enter your **cost-per-credit** rate in USD (this step is skipped if the app can auto-detect it from your organization's rate sheet).
3. Wait for the analysis to complete — typically under **3 minutes**.
4. Review your Efficiency Score, savings estimate, and per-indicator health breakdown.

***

## Troubleshooting

| Issue                                           | Solution                                                                 |
| ----------------------------------------------- | ------------------------------------------------------------------------ |
| App requests privilege but button is grayed out | Ensure you are using a role with `ACCOUNTADMIN` or equivalent privileges |
| Analysis takes longer than expected             | Large accounts with many warehouses may take slightly longer             |
| Cost-per-credit prompt appears unexpectedly     | Your role may not have access to `ORGANIZATION_USAGE` views              |
| Score shows fewer than 4 indicators             | Multi-Cluster Idle Time is skipped on Standard edition accounts          |