Snowflake Optimizer Onboarding

Follow these instructions to onboard to our Snowflake optimizer.

How it works

1. Espresso AI trains custom models on your Snowflake metadata. Training takes about 15 minutes to 48 hours depending on account size.

2. After training, you receive a savings estimate.

3. You get dashboard access to enable optimization across the account or per-warehouse.

Espresso AI uses ML to optimize Snowflake workloads using metadata only (no data access, storage, or logging).

Create a Snowflake user and role

Run the following in Snowflake to set up access for Espresso AI.

-- Create the Espresso AI user
CREATE USER espresso_ai_user 
 TYPE=SERVICE
 RSA_PUBLIC_KEY='MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA6GfMQyT/1ZQS1wwTeF3Q
lbHJyBSuIio+UlnZixffvo9UwP/ild6R4AqOEma39Ty1zuLibbyNSgjTYqNXv7QN
iEgR50SvEo27N6EJI1EOnJPREzi060E64eXMrc1mwPrERxtEtNXgJBUs3Y2aKsGK
oo900jkjK08CrMNBM1uzyXhLBS5a4sNDSlef4JjyZCBl4iHTqmeqD0xZJCC2/Rlr
40UGPq+Ae/zXyyDyQkWE69ytZQRjPXvv8b2x6C9JtKYqtklJljzFy74eQZV4m9hx
tH+r1Z32zyhjNGhYaRF/0yD3gNWg135cexfyd5M8PKPt1Km4VAV6oPr8QYEfvS50
0QIDAQAB';

CREATE ROLE IF NOT EXISTS ESPRESSO_AI_USER
  COMMENT = 'Used by Espresso AI';
  
GRANT ROLE ESPRESSO_AI_USER TO USER ESPRESSO_AI_USER;
CREATE ROLE IF NOT EXISTS ESPRESSO_AI_USER
  COMMENT = 'Used by Espresso AI';

GRANT ROLE ESPRESSO_AI_USER TO USER ESPRESSO_AI_USER;

-- Allow Espresso AI to query Snowflake metadata
GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE
  TO ROLE ESPRESSO_AI_USER;

-- Allow Espresso AI to securely export data
ALTER USER ESPRESSO_AI_USER
  SET PREVENT_UNLOAD_TO_INLINE_URL = false;

-- Allow Espresso AI to monitor warehouses
GRANT MONITOR USAGE ON ACCOUNT
  TO ROLE ESPRESSO_AI_USER;

-- Give Espresso AI the ability to modify warehouses
GRANT MANAGE WAREHOUSES ON ACCOUNT
  TO ROLE ESPRESSO_AI_USER;

-- Set up a warehouse for Espresso AI queries to run on
CREATE WAREHOUSE IF NOT EXISTS
  ESPRESSO_AI_WH WAREHOUSE_SIZE=XSMALL
  AUTO_SUSPEND=60 INITIALLY_SUSPENDED=TRUE
  COMMENT = 'Used by Espresso AI';

GRANT MONITOR, OPERATE, USAGE, MODIFY
  ON WAREHOUSE ESPRESSO_AI_WH
  TO ROLE ESPRESSO_AI_USER;

Share account details

Provide your Snowflake account hostname (the URL you use to log in, e.g. https://<account>.snowflakecomputing.com/) and the role name you created above in the onboarding form at the bottom of this page.

Optional: IP allowlist

If you use Snowflake network policies, allow these IPs:

• 18.233.13.51

• 34.195.242.31

• 34.231.116.52

• 34.231.212.71

• 34.234.123.175

• 35.169.148.94

• 52.87.110.223

• 54.161.160.239

Need help?

Book a call with Espresso AI support if you have questions or want an NDA in place.