Free Snowflake Observability

Welcome!

Espresso AI offers a free suite of observability tooling for your Snowflake account: cost breakdowns, end-to-end latency analysis, a list of your most expensive queries with LLM-suggested optimizations, and more.

A pie chart showing spend breakdown by day

Please run the following commands in Snowflake to get started. This will set up a user account we can use to access the metadata we need for our observability dashboards.

Note that we never access, log, or store any data from Snowflake. We only look at metadata. You can see the list of metadata we access on our docs.

-- Create the Espresso AI user with our public key
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;

-- 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;

Finally, please fill out the form below with your Snowflake account info.
‍
Your account hostname is the URL you use to log into Snowflake, e.g. https://syvmrpv-ycb46914.snowflakecomputing.com/

You'll receive an email once your dashboards are ready!

Optional: IP Whitelist

If you have Snowflake network policies set up, please grant access to 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

Questions? Reach out to support@espresso.ai.