Data Integration Connectors
- Data Integration Connectors
- All Products
Property
| Description
|
---|---|
Username
| The user name to connect to the Snowflake account.
|
Account
| The name of the Snowflake account.
For example, if the Snowflake URL is https://<123abc>.us-east-2.aws.snowflakecomputing.com/console/login#/, your account name is the first segment in the URL before snowflakecomputing.com. Here, 123abc.us-east-2.aws is your account name.
If you use the Snowsight URL, for example, https://app.snowflake.com/us-east-2.aws/<123abc>/dashboard, your account name is 123abc.us-east-2.aws.
Ensure that the account name doesn't contain underscores. If the account name contains underscores, you need to use the alias name. To use an alias name, contact Snowflake Customer Support.
|
Warehouse
| The Snowflake warehouse name.
|
Private Key File
| Path to the private key file, including the private key file name, that the Secure Agent uses to access Snowflake.
For example, specify the following path and key file name in the Secure Agent machine:
On Windows:
C:\Users\path_to_key_file\rsa_key.p8
On Linux:
/export/home/user/path_to_key_file/rsa_key.p8
To use the serverless runtime environment, specify the following path and key file name in the serverless agent directory:
/home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<Private key file name>
For more information about how to use the serverless environment, see
Use the serverless runtime environment with key pair authentication.
Verify that the keystore is FIPS-certified.
|
Property
| Description
|
---|---|
Additional JDBC URL Parameters
| The additional JDBC connection parameters.
You can specify multiple JDBC connection parameters, separated by ampersand (&), in the following format:
For example, you can pass the following database and schema values when you connect to Snowflake:
When you add parameters, ensure that there is no space before and after the equal sign (=).
|
Private Key File Password
| Password for the private key file.
|