Sign up for Espresso AI

Welcome!

Espresso AI makes real-time decisions powered by ML models to optimize your Snowflake workloads.

Here's how it works:
‍
1. First, we need to train custom models on your Snowflake metadata. This will take between 15 minutes and 48 hours, depending on the number of queries and warehouses in your account(s).

2. Once the models are trained you'll receive a savings estimate.

3. You'll also get access to our dashboard, where you can turn the models on either across your account or for specific warehouses.
‍
Please run the following commands in Snowflake. This will set up a user account we can use to both access the metadata we need for our models, as well as to optimize your Snowflake account's operations.

Note that we never access, log, or store any data from Snowflake. We only look at metadata.

CREATE USER espresso_ai_user PASSWORD = '<credentials>'
 TYPE=LEGACY_SERVICE
 MUST_CHANGE_PASSWORD = TRUE;

Please note down the credentials. Next, set up account access:

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 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 and the credentials you selected.

Your account hostname is the URL you use to log into Snowflake, e.g. https://syvmrpv-ycb46914.snowflakecomputing.com/

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?

Book a Call