Onboarding Data from Snowflake

$inline[badge,NOTE,primary] This version of Snowflake connector has been deprecated. However, you can continue to run jobs on previously created CDATA Snowflake sources. To create a source with the newer version of Snowflake connector, refer to $link[page,397268,auto$].

Creating a Snowflake Source

For creating a Snowflake source, see $link[page,397261,auto$]. Ensure that the Source Type selected is Snowflake.

Custom OAuth Parameter Settings

Set the following parameters to authenticate using the client secret of a Custom OAuth app:

Snowflake Configurations

Once the settings are saved, you can test the connection.

Configuring a Snowflake Table

For configuring a Snowflake Table, see $link[page,397016].

Establishing a Connection

To create a JDBC URL, see Establishing a Connection.

Data Model

The tables and views supported by the source are described in the Data Model.

JDBC Connection Parameters

For the list of JDBC connection parameters, see Connection Parameters.