Connect your Snowflake
Last updated
Was this helpful?
Last updated
Was this helpful?
Setting up the Snowflake warehouse connector involves setting up Snowflake entities (warehouse, database, schema, user, and role) in the Snowflake console, and configuring the Snowflake Warehouse connector using Whaly UI.
This page describes the step-by-step process of setting up the Snowflake warehouse connector.
A Snowflake account with the role. If you donโt have an account with the ACCOUNTADMIN
role, contact your Snowflake administrator to set one up for you.
To set up the Snowflake warehouse connector, you first need to create Whaly-specific Snowflake entities (a warehouse, database, schema, user, and role) to read data into Snowflake, track costs pertaining to Whaly, and control permissions at a granular level.
You can use the following script in a new to create the entities:
.
Edit the following script to change the password to a more secure password and to change the names of other resources if you so desire.
Execute the script as an ACCOUNTADMIN
user (check on the top right corner of the Worksheet interface).
Navigate to the Whaly UI to set up Snowflake as a destination. You can authenticate using username/password.
The username you created in Step 1 to allow Whaly to access the database. Example: WHALY_BI_USER
The password associated with the business intelligence user.
Go on the bottom right part of you screen and open your Account Selector.
On the tooltip, select the proper account and click on "Copy account URL"
Go into the "Admin > Account" panel on the right side of the screen
Next to your account name, click on the ๐ icon which will copy the URL on your clipboard!
The Account ID as an URL. Ex. . It can be found in Snowflake web UI in Admin > Accounts and then you cal click on the ๐ icon next to the account name in the table.