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