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

Snowflake Data Cloud Connector

Snowflake Data Cloud Connector

Key pair authentication

Key pair authentication

Key pair authentication requires the private key file and private key file password, along with your Snowflake account user name to connect to Snowflake.
The following table describes the basic connection properties for key pair authentication:
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.

Advanced settings

The following table describes the advanced connection properties for key pair authentication:
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:
<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.
Private Key File Password
Password for the private key file.

0 COMMENTS

We’d like to hear from you!