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