Snowflake setup

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.

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