Free Analysis for Snowflake

Find out how much of your Snowflake spend might be wasted - before you set anything up. The free analysis is built on your own workloads, not a generic benchmark: it pinpoints oversized, idle, and unnecessary compute, and quantifies your potential savings with Yuki in dollars.

Also on the Snowflake Marketplace

Prefer to run the analysis entirely inside your own Snowflake account? Install Yuki - Free Cost Analysis from the Snowflake Marketplace. See Run It From the Snowflake Marketplace.

How It Works

1. Export 30 days of metadata - run a read-only script or a few queries yourself. No query text, no table contents.
2. We replay your real workload - Yuki's optimizer runs against your actual usage to show how your environment would behave with Yuki in place.
3. Get your report by email - see where your compute goes and the dollar value of every fix.

It takes about 3 minutes of your time. No credit card, no commitment. All data is automatically deleted after 30 days, and Yuki is SOC 2 and GDPR compliant.

Step 1 - Start Your Free Analysis

You'll need: the free analysis link and secret key from the Yuki team, your Snowflake credit price, and a Snowflake role that can query SNOWFLAKE.ACCOUNT_USAGE (and create a share, for the Data Share option).

1. Open the free analysis link
2. Enter your Secret Key and business Email
3. Under Which platform should we analyze?, select Snowflake
4. Enter your Snowflake Account Name and click Start

Step 2 - Share Your Data

Yuki asks How should we pull your data? Both options share the same metadata - pick the one that suits your environment.

Data Share (recommended)

Run one SQL script that creates a Snowflake Secure Data Share with Yuki. Fully automatic - best for large-scale environments.

1. Enter your Snowflake Credit Cost ($ per credit)
2. Choose your Snowflake region. If your region isn't listed, contact support@yukidata.com and we'll help you set it up.
3. Copy the script under Run this script in your Snowflake console and run it in Snowflake. Yuki fills in the share details for your region, so copy the script after choosing the region.
4. Enter your Snowflake Account identifier. To find it in Snowflake, click your profile picture (bottom-left) → Connect a tool to Snowflake and copy the Account Identifier.
5. Tick I have run the query and completed the share
6. Click Analyze My Data

Upload CSV

Run 3 queries yourself and upload the results - best for smaller teams.

1. Enter your Snowflake Credit Cost ($ per credit)

2. Run each of the 3 queries shown on the page in Snowflake and export the results to CSV. Click View query to see a query and copy it.

   Upload	What the query reads
   Warehouses	SHOW WAREHOUSES - your warehouse list and settings
   Metering History	Credit usage per warehouse for the last 30 days, from ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY
   Query History (30 days)	Execution statistics per query for the last 30 days, from ACCOUNT_USAGE.QUERY_HISTORY

3. Drop each file into its upload box. You can upload a .csv file, or compress a large CSV into a .zip file.

4. Once all 3 files are added, click Analyze My Data. Yuki shows the upload progress and time left.

What data does Yuki receive?

Both options share the same 30 days of usage metadata from SNOWFLAKE.ACCOUNT_USAGE:

• Warehouses - names, sizes, and settings
• Credit usage - credits used per warehouse over time
• Query execution statistics - timings, queueing, bytes scanned and spilled, rows processed, partitions, and status, plus each query's query tag and error code and message

Query text is never collected. Instead, the query history includes a one-way hash of each query's text, so Yuki can recognize repeated queries without seeing them. All data is automatically deleted after 30 days.

Step 3 - Get Your Report

You'll see Thank You - You're All Set! Yuki analyzes your data and emails your report to you when it's ready.

Your report is a Snowflake workload assessment based on your actual usage. It opens with the percentage of your annual Snowflake spend that Yuki could optimize, and covers:

Section	What it shows
01 Cost breakdown	Spend for the analyzed window, daily average, an efficiency score, projected annual cost by warehouse size (current vs. with Yuki), and daily cost split across your five largest warehouses
02 Warehouse breakdown	Your warehouses ranked by annual savings opportunity, with the share of each warehouse's queries that fit a smaller size and the saving method that applies to it
03 Performance	Idle warehouse time, queue time at P90, and the work delivered per credit - both execution time and GB scanned - each shown as it is today and as it would be optimized
04 The opportunity	Projected annual savings, current vs. optimized run-rate, and daily credit consumption

---

Run It From the Snowflake Marketplace

Yuki - Free Cost Analysis is a Snowflake Native App that runs the same workload assessment entirely inside your own Snowflake account, against your own usage metadata, and produces one report you can export as a PDF.

You'll need: the ACCOUNTADMIN role, and at least a few days of history in ACCOUNT_USAGE for a meaningful analysis window.

Install the App

1. Click Get to install the app in your Snowflake account
2. Grant the three privileges listed below when prompted
3. Approve the external access integration if you want Yuki to follow up with your results. Declining is fine - the report still renders in full.

Run the Analysis

1. Launch the app from your Snowflake account
2. Enter your business email on the welcome screen
3. The app reads your usage metadata, runs the analysis, and renders the report. This normally takes a minute or two, longer on very large accounts.
4. Adjust the credit price to match your contract - every dollar figure updates immediately
5. Export the report as a single-page PDF

Every number has an information icon - hover over it to see the exact SQL that produced it, so you can reproduce any figure in a worksheet.

What the app reads

The app reads two views only, through the IMPORTED PRIVILEGES ON SNOWFLAKE DB grant, over a trailing 30-day window:

• SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY
• SNOWFLAKE.ACCOUNT_USAGE.WAREHOUSE_METERING_HISTORY

It reads query metadata: timings, warehouse names and sizes, bytes scanned, queue times, and execution status. Query text is read for one purpose only - to compute a SHA2 hash so repeated queries can be detected. Only the hash is stored; the raw text is never written to a table and never leaves your account. The app doesn't read query results, table data, user names, role names, or any other user-identifiable information.

What the app creates in your account

Everything stays inside your account:

• A database named cost_analysis, holding the assessment tables
• A warehouse named YUKI_FREE_ANALYSIS_WH, used only to run the assessment. It auto-suspends after 30 seconds. If that name is already taken, the app creates a suffixed one instead and leaves your warehouse untouched.

Privileges the app requests

Privilege	Why
IMPORTED PRIVILEGES ON SNOWFLAKE DB	Read the two usage views
CREATE DATABASE	Create cost_analysis for the assessment tables
CREATE WAREHOUSE	Create the warehouse that runs the assessment

---

Questions? Contact support@yukidata.com.