​
Connecting to Snowflake

For an overview of the connector, please refer to the following link:
1

Create a Connector

Select the “Connectors” tab on the top page and click the “Create” button.Connection
2

Enter Snowflake Credentials

Snowflake offers three authentication methods.Please refer to the official page for the Snowflake Server URL.

​
Connecting with Private Key

Select Snowflake (Key Pair) and enter the required credentials in the displayed form.Snowflake Key Pair Connection Create
Field NameDescriptionRequiredExample
ServerStandard Snowflake Account URL✅https://<account_locator>.<region>.<cloud>.snowflakecomputing.com
UsernameUsername✅DEMO_USER
Private KeyPrivate Key✅-----BEGIN PRIVATE KEY-----
PassphrasePrivate Key Passphrasepassphrase
Please refer to the official page for creating a private key.

​
Connecting with User/Password

Select Snowflake (user / password) and enter the required credentials in the displayed form.
Please note that if two-factor authentication is enabled, approval will be required each time.
Snowflake ID Password Connection Create
Field NameDescriptionRequiredExample
ServerStandard Snowflake Account URL✅https://<account_locator>.<region>.<cloud>.snowflakecomputing.com
UsernameUsername✅DEMO_USER
PasswordPassword✅password

​
Connecting with OAuth

Select Snowflake (OAuth) and enter the required credentials in the displayed form.Snowflake OAuth Connection Create
Field NameDescriptionRequiredExample
ServerStandard Snowflake Account URL✅https://<account_locator>.<region>.<cloud>.snowflakecomputing.com
Client IdClient ID✅CLIENT_ID
Client SecretClient Secret✅CLIENT_SECRET
Please refer to the official page for creating a Client ID and Client Secret.After entering the information, click the Create button to complete the creation. If there are any errors, please check the connection details again.
3

Connect to the Created Database

Once successfully created, you can obtain the connector name from the list display. The string next to the icon is connection_name. You can use this to connect to the database in your code.Snowflake Connection Create CompleteEnter the created connector name in your SQL or Python code to retrieve data.
{{
    config(
        connection="connection_name"
    )
}}

select * from table_name