Administrator
- Administrator
- All Products
Connection property
| Description
|
---|---|
Connection Name
| Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
|
Description
| Description of the connection. Maximum length is 4000 characters.
|
Type
| The Snowflake Data Cloud connection type.
|
Runtime Environment
| The name of the runtime environment where you want to run the tasks.
Specify a Secure Agent, Hosted Agent, or serverless runtime environment.
Hosted Agent is not applicable for mappings in advanced mode.
You cannot run application ingestion tasks and database ingestion tasks on a Hosted Agent or serverless runtime environment.
|
Authentication
| The authentication method to log in to Snowflake.
Select
KeyPair .
|
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. To use an alias name, contact Snowflake Customer Support.
|
Warehouse
| The Snowflake warehouse name.
|
Additional JDBC URL Parameters
| The additional JDBC connection parameters.
Enter one or more JDBC connection parameters in the following format:
For example, pass the database and schema values when you connect to Snowflake:
Ensure that there is no space before and after the equal sign (=) when you add the parameters.
|
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:
On Windows:
C:\Users\path_to_key_file\rsa_key.p8 On Linux:
/export/home/user/path_to_key_file/rsa_key.p8 Verify that the keystore is FIPS-certified.
|
Private Key Password
| Password for the private key file.
|