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.

  1. Login and Password
FieldDescription
HostThe 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
WarehouseThe Snowflake warehouse to be used for processing queries.
DatabaseThe specific database in Snowflake to connect to.
SchemaThe schema within the database you want to access.
UsernameThe username associated with your account
PasswordThe 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
  1. Oauth 2.0

    Coming soon

Supported sync modes

ModeSupported (Yes/No/Coming soon)
Incremental syncYES
Full refreshComing soon