Sign up for Espresso AI

Welcome! To get started with Espresso AI, please run the following commands
in Snowflake.

First, create a new user account for Espresso (with a unique password):

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;
  
-- Allow Espresso AI to read the schema definitions (not the contents) of all views/tables
DECLARE
    db text;
    c1 CURSOR FOR SELECT database_name FROM SNOWFLAKE.INFORMATION_SCHEMA.DATABASES where type = 'STANDARD';
BEGIN
  FOR record in c1 DO
    db := record.database_name;
    EXECUTE IMMEDIATE 'grant usage on DATABASE IDENTIFIER(?) to role espresso_ai_user' USING (db);
    EXECUTE IMMEDIATE 'grant usage on ALL SCHEMAS IN DATABASE IDENTIFIER(?) to role espresso_ai_user' USING (db);
    EXECUTE IMMEDIATE 'grant usage on future SCHEMAS IN DATABASE IDENTIFIER(?) to role espresso_ai_user' USING (db);
    EXECUTE IMMEDIATE 'grant REFERENCES on all tables in database IDENTIFIER(?) to role espresso_ai_user' USING (db);
    EXECUTE IMMEDIATE 'grant REFERENCES on all views in database IDENTIFIER(?) to role espresso_ai_user' USING (db);
    EXECUTE IMMEDIATE 'grant REFERENCES on future tables in database IDENTIFIER(?) to role espresso_ai_user' USING (db);
    EXECUTE IMMEDIATE 'grant REFERENCES on future views in database IDENTIFIER(?) to role espresso_ai_user' USING (db);
  END FOR;
END;

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/

Thank you! We'll be in touch shortly.
Oops! Something went wrong while submitting the form.

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