Setting Snowflake Data Connection
Following are the Snowflake connection details:
| Field | Description |
|---|---|
| Connection Type | Type of connection. Select Snowflake. |
| Name | Name for the target data connection. For example, tar_con. |
| Description | Description for the target data connection. |
| Account Name | The Snowflake account name. The full account name might include additional segments that identify the region and cloud platform where the account is hosted. For example, xy12345 for US West (Oregon), xy12345.us-east-2.aws for US East (Ohio), and xy12345.us-east-1 US East (N. Virginia). |
| Connection URL | The URL to connect to Snowflake which specifies the hostname for the account in the format, Example 1: Example 2: For more information regarding additional parameters, refer to JDBC Connection Parameters. |
| User Name | Username of the snowflake account. For example, mark@example.com. |
| Password | Password of the snowflake account. For example, 123456. |
| Warehouse | Snowflake warehouse name. For example, sales. |
| Additional Params | Optional JDBC parameters. |
| Private Key | Provide the private key associated with the Snowflake user for key-pair authentication. This field is required if Key-Pair authentication is selected. The private key must be in PEM format. Ensure the private key is properly encrypted or securely stored. The corresponding public key must be registered with the Snowflake user account. |
| Is Private Key Encrypted? (Checkbox) | Enable this option if the private key is encrypted with a passphrase. When checked, an additional field for the Private Key Passphrase will be displayed. |
| Private Key | PassphraseProvide the passphrase used to encrypt the private key.
This field is required if Is Private Key Encrypted? is selected. The passphrase must match the one used when generating the encrypted private key. Ensure the passphrase is securely stored. |
Was this page helpful?