🔌Add a Snowflake connector
Configuring a Snowflake connection
Fill out the form with the following info:
Name (mandatory)
String
Use it to identify your connection
MySnowflakeConnection
Account (mandatory)
String
in the form account_id.region_id.cloud_platform
. When you connect to your snowflake UI, it is the first part of the url <account_identifier>.snowflakecomputing.com
. You can read more about it here
<account_identifier>
Authentication method (mandatory)
Enum
List with Snowflake (ID+Password)
(deprecated by Snowflake in November 2025) Key pair
and oAuth
(deprecated)
Key pair
User
String
- Snowflake (ID+Password)
- Key pair
The user with rights to access to the Snowflake database
my_snowflake_user
Password
String
- Snowflake (ID+Password)
- Key pair
Password associated to the user or to the private key if your key is protected by a password (will be stored as a secret)
mysecretpassword
Private Key
String
- Key pair
the key generated to access to your Snowflake database the key in PEM-encoded PKCS#8 format (will be stored as a secret)
-----BEGIN ENCRYPTED PRIVATE KEY----- MIIJpDBW[...]-----END ENCRYPTED PRIVATE KEY-----
Token Endpoint
String
- oAuth
The token endpoint URL
https://<your_snowflake_account>.snowflakecomputing.com/oauth/token-request
Token Endpoint Content Type
String
- oAuth
The content type to use when requesting the token endpoint
application/x-www-form-urlencoded
Default Warehouse (mandatory)
String
The default warehouse that shall be used for any data source
COMPUTE_WH
Retry Policy (optional)
Boolean
Boolean allows to configure a retry policy if the connection is flaky.
max attempts: maximum number of retries before giving up
max_delay: in seconds, above the connection is dropped
wait_time: time in seconds between each retry
Slow Queries' Cache Expiration Time (optional)
Integer
Slow queries' cache expiration time in seconds
Click on the
TEST CONNECTION
button thenSAVE
the connectionAfter successfully configuring the connector, you will be able to find it in the Connector section of the DataHub "Datasource" tab
Create a dataset from a Snowflake connection
To create a dataset from Snowflake, click on the "create from" icon, you will then be able to:
Select the
Database
Select the
Data warehouse
Select the
Schema
Select
Table
orViews
Only keep the columns you need
After selecting data from your connector you will be able to create a dataset thanks to YouPrep using the selection as "source step".
Last updated
Was this helpful?