Data Integration Connectors
- Data Integration Connectors
- All Products
Property
| Description
|
|---|---|
Username
| The user name to connect to the Snowflake account.
|
Password/PAT
| The password or programmatic access token (PAT) to connect to the
Snowflake account. Enter the password of your Snowflake
account or the PAT granted by Snowflake. For more information about how to generate a PAT, see Generate the programmatic
access token. |
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.
|
Property
| Description
|
|---|---|
Role
| The Snowflake role assigned to the user.
|
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 (=).
For the list of additional JDBC parameters that you can configure, see
JDBC URL parameters.
|