Snowflake Connection Details
To establish the connection successfully, you must configure the Snowflake instance.
The Snowflake Connector dialog contains the following fields:
| Field | Required | Description |
|---|---|---|
| Connection Name | Yes | Unique name for the Snowflake connector. This name is displayed in the dropdown selection boxes for each activity. |
| Description | No | Brief description of the Snowflake connection. |
| Account Name | Yes | Account name for your Snowflake domain. |
| Warehouse | Yes | Warehouse for your Snowflake domain. |
| Database | Yes | Database for your Snowflake warehouse. |
| Schema | No | Schema for your Snowflake database. |
| Authentication Type | Yes |
Authentication type that is used to connect to the Snowflake domain. The available values listed are:
By default Basic Authentication is selected. |
| Username | Yes | Username for connecting to your Snowflake domain. This field is visible when the authentication type is Basic Authentication. |
| Password | Yes | Password for connecting to your Snowflake domain. This field is visible when the authentication type is Basic Authentication. |
| Provider | Yes |
The OAuth authentication type that is used to connect to the Snowflake domain. This field is visible when the OAuth authentication type is selected. The available values listed are:
By default Snowflake is selected. |
| Client ID | Yes | Client ID of the integration object. This field is visible when the authentication type is OAuth. |
| Client Secret | Yes | Client secret of the integration object. This field is visible when the authentication type is OAuth and the Provider is Snowflake. |
| Okta Token Endpoint | Yes | The token _endpoint parameter from the metadata document of the Okta Authorization Server. This field is visible when the authentication type is OAuth and the Provider is Okta with PKCE. |
| Scope | Yes |
Scope specifies what access privileges are being requested as part of the authorization. Any specific custom scope needs to be added along with offline_access to get an access token and a refresh token. This field is visible when the authentication type is OAuth and the Provider is Okta with PKCE. |
| Authorization Code | Yes | Authorization code to authorize the generation of access token and refresh token. This field is visible when the authentication type is OAuth. |
| Redirect URI | Yes | Redirect URI of the integration object. This field is visible when the authentication type is OAuth. |
| Code Verifier | Yes |
Code verifier is a cryptographically random key that is eventually sent to request tokens. Minimum length of characters: 43 Maximum length of characters: 128 This field is visible when the authentication type is OAuth and the Provider is Okta with PKCE. |
| Code Challenge | Yes | The Code Challenge is a Base64-encoded SHA-256 hash of the Code Verifier. This field is visible when the authentication type is OAuth and the Provider is Okta with PKCE. |
| Role | No | Role to be used for creating a connection to the Snowflake domain. This field is visible when the authentication type is Basic Authentication. The default role is used when this field is left blank. |
| Login Timeout | Yes | Time out value to connect to your Snowflake domain. |
For more information about the fields, see the Snowflake documentation.