🔌Add a Snowflake connector

Configuring a Snowflake connection

Fill out the form with the following info:

Field
Format / Type
Description
Example

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

Role (optional)

String

The user role that you want to connect with. See more details here.

USER

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 then SAVE the connection

Create a dataset from a Snowflake connection

This data connector is supported in simple and code/SQL mode for our current Data Execution system

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 or Views

  • Only keep the columns you need

For more info, see the dedicated section Create a new dataset from a dataset

Last updated

Was this helpful?