Onboarding Data from Snowflake

NOTE 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 Onboarding Data from Snowflake Source.

Creating a Snowflake Source

For creating a Snowflake source, see Configuring Additional Connectors. 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:

OAuth Parameter	Description
OAuthClientId	Set to the Client ID in your OAuth Integration settings.
OAuthClientSecret	Set to the Client Secret in OAuth your Integration settings.
CallbackURL	Set to the Redirect URL in your OAuth Integration settings.

Snowflake Configurations

Field	Description
Fetch Data Using	The mechanism through which Infoworks fetches data from the database.
Connection URL	The connection URL through which Infoworks connects to the database.
Username	The username for the connection to the database.
Password	The password for the username provided.
Source Schema	The schema in the database to be crawled. The schema value is case sensitive.

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

Configuring a Snowflake Table

For configuring a Snowflake Table, see Configuring a Table.

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.

Last updated on Jun 21, 2022

Was this page helpful?