Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with Snowflake Data Cloud Connector
  3. Part 2: Data Integration with Snowflake Data Cloud Connector
  4. Part 3: SQL ELT with Snowflake Data Cloud Connector
  5. Appendix A: Data type reference
  6. Appendix B: Additional runtime configurations
  7. Appendix C: Upgrading to Snowflake Data Cloud Connector
  8. Appendix D: Troubleshooting

Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Standard authentication

Standard authentication

Standard authentication is the default type and the minimum requirement for a standard authentication is the Snowflake account name, warehouse name, user name, and either your account password or a programmatic access token (PAT).
The following table describes the
basic
connection properties for standard authentication:
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.

Advanced settings

The following table describes the advanced connection properties for standard authentication:
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:
<param1>=<value>&<param2>=<value>&<param3>=<value>....
For example, you can pass the following database and schema values when you connect to Snowflake:
db=mydb&schema=public
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.

0 COMMENTS

We’d like to hear from you!