Installation

Step-by-step guide to installing and launching the Snowflake Efficiency Score app from the Snowflake Marketplace.

Step 1 — Find the App on Snowflake Marketplace

1. Log in to your Snowflake account via Snowsight.

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