For creating a Snowflake source, see Configuring Additional Connectors. Ensure that the Source Type selected is Snowflake.
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. |
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.
For configuring a Snowflake Table, see Configuring a Table.
To create a JDBC URL, see Establishing a Connection.
The tables and views supported by the source are described in the Data Model.
For the list of JDBC connection parameters, see Connection Parameters.