Overview
In order to connect to a Snowflake database, you will need a user account in Snowflake with permissions to access your data. Then, in the app, enter the account id, database, user and password to let Steep connect to your database.
Account ID
Example: ab12345.europe-west4.gcp
This is the first part of the Locator URL that you can find in the Snowflake console.
Database
Example: MY_COMPANY
User
Example: steep
Password
Example: ******
Setting up a user account in Snowflake
We recommend that you create a new user and role specifically for Steep. This is best done in a worksheet in the Snowflake console. See below for a step-by-step guide.
1. New worksheet
Head to the Snowflake console, navigate to Worksheets and create a new worksheet.
2. Create role and user
Example SQL script below. Please replace all <brackets> with your details.
-- Create Role CREATE ROLE IF NOT EXISTS STEEP; GRANT USAGE ON WAREHOUSE <COMPUTE_WH> TO ROLE STEEP; GRANT USAGE ON DATABASE <MY_DATABASE> TO ROLE STEEP; GRANT USAGE ON SCHEMA <MY_SCHEMA> TO ROLE STEEP; GRANT SELECT ON ALL TABLES IN SCHEMA <MY_SCHEMA> TO ROLE STEEP; -- Create User CREATE USER IF NOT EXISTS steep PASSWORD = '<unique-password>' MUST_CHANGE_PASSWORD = FALSE DEFAULT_ROLE = STEEP; GRANT ROLE STEEP TO USER steep; ALTER USER steep SET DEFAULT_WAREHOUSE = <COMPUTE_WH>;
3. Enter credentials in Steep
Copy the user and password to the corresponding fields in the Steep database form. Test the connection to make sure things are working fine.
Finding your Account ID in Snowflake
Your Snowflake Account ID can be found in the Snowflake console by navigating to Organization and clicking on the Locator URL link for your account.
The Account ID is the first three parts of the Locator URL. Example: https://**ab12345.europe-west4.gcp**.snowflakecomputing.com