Snowflake cost optimization

Find the waste inside your Snowflake. Free.

Export three CSV files from your Snowflake worksheet in under 5 minutes. Upload them here and our cost intelligence model - trained on Snowflake spend patterns - pinpoints exactly where money is being wasted, with dollar amounts on every finding.

No database access requiredFiles never leave your browserFree forever

Run each query below in your Snowflake worksheet. After each one, click Download results - CSV in the results panel. You will have three files to upload on the next step.

Snowflake SQL - run each query separately
-- Query 1: Last 30 days of query activity (capped at 500,000 rows)
-- The LIMIT keeps the export file under ~60MB for fast browser processing.
-- Rows are ordered newest-first so the most recent activity is always included.
SELECT
  query_id,
  user_name,
  warehouse_name,
  warehouse_size,
  query_type,
  ROUND(execution_time / 1000, 2)       AS execution_time_s,
  ROUND(bytes_scanned / 1073741824, 4)  AS bytes_scanned_gb,
  credits_used_cloud_services           AS credits_used,
  query_tag,
  start_time
FROM snowflake.account_usage.query_history
WHERE start_time >= DATEADD(day, -30, CURRENT_TIMESTAMP())
  AND execution_status = 'SUCCESS'
ORDER BY start_time DESC
LIMIT 500000;

-- Query 2: Warehouse credit consumption
SELECT
  warehouse_name,
  SUM(credits_used)                                             AS credits_used,
  SUM(credits_used_compute)                                     AS credits_used_compute,
  SUM(credits_used_cloud_services)                              AS credits_used_cloud_services,
  ROUND(SUM(DATEDIFF('minute', start_time, end_time)) / 60, 2) AS hours_active
FROM snowflake.account_usage.warehouse_metering_history
WHERE start_time >= DATEADD(day, -30, CURRENT_TIMESTAMP())
GROUP BY 1
ORDER BY credits_used DESC;

-- Query 3: Warehouse configuration
SHOW WAREHOUSES;

Tip - how to export from Snowflake

Run each query - in the results panel, click the download icon in the top-right corner - select Download as .csv. Query 1 may take a minute to run on large accounts.