Infoworks 6.1.3
Onboard Data
Additional Connectors

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 ParameterDescription
OAuthClientIdSet to the Client ID in your OAuth Integration settings.
OAuthClientSecretSet to the Client Secret in OAuth your Integration settings.
CallbackURLSet to the Redirect URL in your OAuth Integration settings.

Snowflake Configurations

FieldDescription
Fetch Data UsingThe mechanism through which Infoworks fetches data from the database.
Connection URLThe connection URL through which Infoworks connects to the database.
UsernameThe username for the connection to the database.
PasswordThe password for the username provided.
Source SchemaThe 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