Snowflake Credentials

Please note that users must create a credential within Snowflake BEFORE creating a credential in DataBlend.

To learn more about setting up a credential within Snowflake, please visit https://docs.snowflake.com/en/user-guide/oauth-custom.

To make a Snowflake connection, the following credentials are needed:

Field Name	Required/ Optional	Description
Type	Required	Snowflake
Name	Required	Provide a unique name for this credential
Client Id	Required	Enter Client Id found on the user’s Snowflake profile
Client Secret	Required	Enter Client Secret found on the user’s Snowflake profile
Base URL	Required	Enter Snowflake Base URL found on the user’s Snowflake profile Example: `https://ab12345.1.aws.snowflakecomputing.com`
Locator Id	Required	Enter the unique Locator Id found on the user’s Snowflake profile. Retrieve your Snowflake locator ID. This is found in the left sidebar.
Access Token	Not Applicable	Leave blank. This field will auto-populate when connected to Snowflake.
Refresh Token	Not Applicable	Leave blank. This field will auto-populate when connected to Snowflake.

Users must enter the Client ID and Client Secret from the Snowflake security integration.

Navigate to Admin → Security → Create New Network Rule (top right corner in UI)
Enter a unique name
Select Database and Add Datablend IP to Identifiers
Create new network policy
Enter a unique name
Add the Allowed security rule for the Datablend IP address
In a Project worksheet enter the info from the Snowflake set up documentation.
Change the username and selected database.
Once entered, it wll generate the token.
Users must you copy/paste to a notepad. Please note that users cannot retrieve the token after generation. Users are allowed only 15 tokens per user.