Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
Connection property
| Description
|
---|---|
Connection Name
| Name of the connection.
The name is not case sensitive. It must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
|
Description
| Optional. Description that you use to identity the connection.
The description cannot exceed 765 characters.
|
Type
| The Snowflake Data Cloud connection type.
|
Runtime Environment
| The name of the runtime environment where you want to run the tasks.
You cannot run application ingestion tasks and database ingestion tasks on a Hosted Agent or serverless runtime environment.
|
Authentication
| Select the authentication method that the connector must use to log in to Snowflake.
Select
Standard . Default is
Standard .
|
Username
| The user name to connect to the Snowflake account.
|
Password
| The password 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.
Here,
123abc.us-east-2 is your account name.
For the Snowsight URL, for example,
https://app.snowflake.com/us-east-2.aws/123abc/dashboard , your account name is
123abc.us-east-2 .
Ensure that the account name does not contain underscores. To use an alias name, contact Snowflake Customer Support.
|
Warehouse
| The Snowflake warehouse name. You must specify the warehouse name.
|
Role
| The Snowflake role assigned to the user.
|
Additional JDBC URL Parameters
| Optional. The additional JDBC connection parameters.
Enter one or more JDBC connection parameters in the following format:
For example:
Ensure that there is no space before and after
= when you add the parameters.
|