Source/Snowflake

Overview

This Snowflake source connector is built on top of the ODBC and is configured to rely on the Snowflake ODBC driver as described in Snowflake documentation.

Setup

Authentication

Authentication is supported via two methods: username/password and OAuth 2.0.

Login and Password

Field	Description
Host	The host domain of the Snowflake instance. Must include the account, region, cloud environment, and end with snowflakecomputing.com. Example: accountname.us-east-2.aws.snowflakecomputing.com
Warehouse	The Snowflake warehouse to be used for processing queries.
Database	The specific database in Snowflake to connect to.
Schema	The schema within the database you want to access.
Username	The username associated with your account
Password	The password associated with the username.
JDBC URL Params	(Optional) Additional properties to pass to the JDBC URL string when connecting to the database formatted as key=value pairs separated by the symbol &. Example: key1=value1&key2=value2&key3=value3

Oauth 2.0 Coming soon

Supported sync modes

Mode	Supported (Yes/No/Coming soon)
Incremental sync	YES
Full refresh	Coming soon