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 ROLE SYSADMIN;
-- Snowflake best practice
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 and retrieve query statistics
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/