Data warehouse cost optimization

Find the waste inside your Snowflake. Free.

Connect your Snowflake account in 60 seconds. We pull only usage metadata, run an AI-powered audit, and show you exactly where money is being wasted - with dollar amounts on every finding.

Read-only access onlyNo data storedCredentials used once

Run this block as ACCOUNTADMIN in Snowflake Worksheets

Setup SQL — Steps 1 to 5
-- Run this entire block as ACCOUNTADMIN in Snowflake Worksheets

-- Step 1: Create the read-only role
CREATE ROLE IF NOT EXISTS DATALENS_READONLY;

-- Step 2: Grant access to Snowflake system metadata only
-- This allows reading ACCOUNT_USAGE views (query history, warehouse
-- metering, login history etc.)
-- This does NOT grant access to any of your databases, tables,
-- schemas, or business data
GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE
  TO ROLE DATALENS_READONLY;

-- Step 3: Grant usage on a warehouse so metadata queries can run
-- DataLens only uses this to query system views, not your data
-- You can revoke this after the audit is complete
GRANT USAGE ON WAREHOUSE COMPUTE_WH
  TO ROLE DATALENS_READONLY;

-- Step 4: Assign the role to your user
-- Replace YOUR_USERNAME with your Snowflake username (appears twice)
GRANT ROLE DATALENS_READONLY TO USER YOUR_USERNAME;

-- Step 5: Verify the setup worked (run this separately after the above)
-- USE ROLE DATALENS_READONLY;
-- SELECT COUNT(*) FROM snowflake.account_usage.query_history;
-- If this returns a number, setup is complete.

Replace YOUR_USERNAME with your Snowflake username in Step 4. Run Steps 1 to 4 as one block. The optional Step 5 can be run separately to verify access is working.

What this role can access

  • Query history (who ran what, when, how much compute it used)
  • Warehouse metering (credits consumed per warehouse)
  • Other Snowflake system metadata about compute usage

What this role cannot access

  • Any of your databases, tables, or schemas
  • Any actual data your team has stored in Snowflake
  • Passwords, credentials, or security configurations
  • Any object you have created in Snowflake