Snowflake

Prerequisites

5X uses static IPs to connect to your warehouse, please make sure your firewall is configured to allow the connection from these IP addresses.

3.217.202.216
3.211.173.46
174.129.146.62

Setup

For 5X to access your Snowflake, you need to create a dedicated user for 5X and assign the required roles: ACCOUNTADMIN, SECURITYADMIN and SYSADMIN.

We recommend to name as fivex_user and 5X will use this user to manage user access and query utilization insights.

Step One - Create a new user

You need to have ACCOUNTADMIN privilege in order to create a new user for 5X. Open any worksheet on your Snowflake and run this script.

USE ROLE accountadmin;

CREATE USER fivexx_user PASSWORD='yourpassword' DEFAULT_ROLE = ACCOUNTADMIN;

GRANT ROLE accountadmin TO USER fivexx_user;

Step Two- Enter details on 5X

Snowflake Account

This is your Snowflake host, you can get the link from your Snowflake web interface URL.

Please note that this is the URL used for accessing Snowflake. (e.g. https://abc01234.us-east-1.snowflakecomputing.com)

Username

Username of the user you created above (e.g. fivex_user)

Password

The password that you set for the user (e.g. abc123)

Step Three -Validate details on 5X

Once you have entered the details click on validate we will check the Snowflake credentials before adding the account to 5X account.