Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Data Integration Connections

Data Integration Connections

Key pair authentication

Key pair authentication

Before you use key pair authentication, you must generate the public and private key pair using OpenSSL. The key pair authentication method requires a 2048-bit RSA key pair. Specify the path to the private key file and password in the connection properties to access Snowflake.
The following table describes the Snowflake Cloud Data Warehouse connection properties for the KeyPair authentication type connection:
Connection property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
Hosted agent and serverless runtime environment is not applicable.
Authentication
The authentication method that Snowflake Cloud Data Warehouse V2 Connector must use to log in to Snowflake.
Select
KeyPair
.
Username
The user name to connect to the Snowflake Cloud Data Warehouse account.
Account
The name of the Snowflake account.
In the Snowflake URL, your account name is the first segment in the domain.
For example,
123abc
is your account name in
https://123abc.snowflakecomputing.com
.
Ensure that the account name does not contain underscores. To use an alias name, contact Snowflake Customer Support.
Warehouse
The Snowflake warehouse name.
Additional JDBC URL Parameters
Optional. The additional JDBC connection parameters.
Enter one or more JDBC connection parameters in the following format:
<param1>=<value>&<param2>=<value>&<param3>=<value>....
For example:
user=jon&warehouse=mywh&db=mydb&schema=public
Ensure that there is no space before and after
=
when you add the parameters.
Refer to the following examples of additional JDBC connection parameters that you can configure:
  • To override the database and schema name used to create temporary tables in Snowflake, enter the database and schema name in the following format:
    ProcessConnDB=<DB name>&ProcessConnSchema=<schema_name>
  • To view only the specified database and schema while importing a Snowflake table, specify the database and schema name in the following format:
    db=<database_name>&schema=<schema_name>
  • To access Snowflake through Okta SSO authentication, enter the web-based IdP implementing SAML 2.0 protocol in the following format:
    authenticator=https://<Your_Okta_Account_Name>.okta.com
    Microsoft ADFS is not applicable.
  • To load data from Google Cloud Storage to Snowflake for pushdown optimization, enter the Cloud Storage Integration name created for the Google Cloud Storage bucket in Snowflake in the following format:
    storage_integration=<Storage Integration name>
    For example, if the storage integration name you created in Snowflake for the Google Cloud Storage bucket is
    gcs_int_qa
    , you must specify the integration name in uppercase:
    storage_integration=GCS_INT_QA
Private Key File
Path to the private key file, including the private key file name, that the Secure Agent uses to access Snowflake.
Private Key Password
Password for the private key file.