Snowflake

AWS

jdbc:snowflake://<account_name>.snowflakecomputing.com

Microsoft Azure

jdbc:snowflake://<account_name>.<region>.azure.snowflakecomputing.com

Google Cloud Platform (GCP)

jdbc:snowflake://<account_name>.<region>.gcp.snowflakecomputing.com

Label*

None.

Required. Unique user-provided label for the account.

Default Value: N/A

Example: ELT SF AWS Account AD OFF

Account Properties*

Use this fieldset to configure the information required to establish a JDBC connection with the account.

This fieldset consists of the following fields:

• Database Type

• Download JDBC Driver Automatically

• JDBC JAR(s) and/or ZIP(s)

• JDBC Driver Class

• JDBC URL

• Username

• Password

• Default Database Name

Database Type*

None.

Select the target data warehouse into which the queries must be loaded, that is Snowflake. This activates the following fields:

• Warehouse

• Source Location

Default Value: N/A

Example: Snowflake

Download JDBC Driver Automatically

None.

Select this checkbox to allow the Snap account to download the certified JDBC Driver for Snowflake. The following fields are disabled when you select this checkbox.

• JDBC JAR(s) and/or ZIP(s)

• JDBC driver class

To use a JDBC Driver of your choice, clear this checkbox, upload (to SLDB), and choose the required JAR files in the JDBC JAR(s) and/or ZIP(s): JDBC Driver field. 

Default Value: Not Selected

Example: Selected

JDBC JAR(s) and/or ZIP(s): JDBC Driver

Required when the Download JDBC Driver Automatically checkbox is not selected.

Upload the JDBC driver and other JAR files that you want to use into SLDB. Click 

Default Value: N/A

Example: snowflake-jdbc-3.12.16.jar

JDBC driver class*

Required when the Download JDBC Driver Automatically checkbox is not selected.

Specify the driver class to use for your application. We recommend that you use net.snowflake.client.jdbc.SnowflakeDriver to suit your Snowflake database, as other classes and methods may change due to future enhancements.

Default Value: N/A

Example: net.snowflake.client.jdbc.SnowflakeDriver

JDBC URL*

None.

Enter the JDBC driver connection string that you want to use in the syntax provided below. See Snowflake's JDBC Connection Parameters for more information. 

• jdbc:snowflake://<full_account_name>.snowflakecomputing.com

Alternatively, you can make use of the Username, Password, and Database Name fields, along with the Advanced Properties > URL Properties fieldset to provide the parameters required for building your JDBC URL. See Passing your JDBC URL for more information.

Default Value: N/A

Example:jdbc:snowflake://xy12345.us-east-2.aws.snowflakecomputing.com, jdbc:snowflake://xy12345.east-us-2.azure.aws.snowflakecomputing.com

Authentication Types

None.

Select one of the following modes of authentication that you want to use to access your Snowflake instance.

• Basic: Activates Username and Password fields.

• OAuth2: Activates a series of fields needs for OAuth2 type of authentication

  • Client ID, Client secret, Access token, Refresh token, Access token expiration, OAuth2 Endpoint, OAuth2 Token, Auto-refresh token, Authorize, and Refresh.

  • See Snowflake OAuth User Guide to learn how to obtain values for the above fields.

• Key Pair: Activates Private Key and Encrypted Private Key Passphrase fields. For more information, see Key Pair Authentication & Key Pair Rotation — Snowflake Documentation.

Username*

Authentication Types is Basic.

Enter the username provided for your database account.

Default value: N/A

Example: SFBigdata

Password*

Authentication Types is Basic.

Enter the password corresponding to the username specified above.

Default value: N/A

Example:<Encrypted>

Private Key*

Authentication Type is Key Pair.

Specify the key that you have generated for authentication. The key must include the generated header and footer.

The private key is read, decrypted if necessary, and included with properties to connect to Snowflake, where it is validated against its paired public key to authenticate the connection.

Learn more about Key Pair Authentication & Key Pair Rotation — Snowflake Documentation.

Default Value: N/A
Example:
-----BEGIN PRIVATE KEY-----MIIE6TAbBgkqhkiG9w0BBQM
wDgQILYPyennlX2bd8yX8x
OxGSGfvB+99+PmSlex0FmY9ov1J8H1H9Y3lJXXb

-----END PRIVATE KEY-----

Encrypted Private Key Passphrase

Authentication Type is Key Pair.

Specify the passphrase for the encrypted private key.

Default Value: N/A
Example: Nki62lmWfFO75Xg04W+Fnlt9ejiMn4zPbkf/me Aq1R3X7CM/ORLuLms4vU70NjzNYo09SOUXhQmoqpEkQBvrrYuzdaQt5hvwh7vZQh WZ5L8+lTRoAneFtmd6LZ94AssA==

Warehouse*

Database Type is Snowflake

Enter the name of the Snowflake warehouse that you want to use.

Default value: N/A

Example: 12345abcdefghikj1km2345no

Default Database Name*

None.

Enter the name of the database to use by default. This database is used if you do not specify one in the ELT Select, ELT Insert-Select, or ELT Merge Into Snaps. 

Default value: N/A

Example: EMPLOYEEDB

Client ID

Authentication Types is OAuth2.

Enter the client ID associated with your OAuth integration. You can create the client ID by creating an OAuth integration between your client and Snowflake.

Default value: N/A

Example: YmkCxrn03kty78shYstvFgObIrw=

Client secret

Authentication Types is OAuth2.

Enter the client secret associated with the above client ID.

Default value: N/A

Example: <An encrypted value>

Access token

Authentication Types is OAuth2.

Auto-generated upon authorization—when you click Authorize or Refresh or during an Auto-refresh action.

The access token associated with your OAuth integration is used to make API requests on behalf of the user associated with the client ID. This token is valid for 10 minutes. Select Auto-refresh token checkbox to refresh the token automatically.

Default value: N/A

Example: <An encrypted value>

Refresh token

Authentication Types is OAuth2.

Auto-generated upon authorization—when you click Authorize or Refresh or during an Auto-refresh action.

You need to specify the refresh token retrieval for the application when setting up the OAuth integration. When the OAuth2 flow is executed, the resulting refresh token is stored in this field.

If the refresh token is stored and is valid (within 90 days of its generation), then the access token can be refreshed automatically before it expires.

Default value: N/A

Example: <An encrypted value>

Access token expiration

Authentication Types is OAuth2.

Auto-generated and displayed upon authorization—when you click Authorize or Refresh or during an Auto-refresh action.

The number of seconds remaining until the Access token expires.

OAuth2 Endpoint

Authentication Types is OAuth2.

Enter the URL of your OAuth2 endpoint that the client must call to request authorization codes needed for generating Access and Refresh tokens.

Default value: N/A

Example: https://<account_full_name_from_SF>.snowflakecomputing.com/oauth/authorize

OAuth2 Token

Authentication Types is OAuth2.

Enter the URL of your OAuth2 endpoint that the client must call to request for Access and Refresh tokens.

Default value: N/A

Example: https://<account_full_name_from_SF>.snowflakecomputing.com/oauth/token-request

Auto-refresh token

Authentication Types is OAuth2.

Select this checkbox to enable the Snap account to refresh the Access token before it expires, using the Refresh token, if available.

Default value: Not selected

Example: Selected

Authorize

Authentication Types is OAuth2.

Click this button after providing your Client ID, Client secret, and the endpoint URLs above, to generate an Access token and a Refresh Token. These tokens are displayed in encrypted mode along with the actual value of Access token expiration.

Default value: N/A

Example: N/A

Refresh

Authentication Types is OAuth2.

Click this button after providing your Client ID, Client secret, and the endpoint URLs above, to manually refresh the Access token when it is about to expire. The updated tokens are displayed in encrypted mode. The new Access token expiration value indicates that the Access token is updated.

Default value: N/A

Example: N/A

Source Location*

None.

Select the source data warehouse from which to load data into the Snowflake target database. You must configure this field if you want to use the ELT Load Snap. 

Available options are:

• None

• S3. Activates the Authentication, S3 Bucket, and S3 Folder fields.

• Azure. Activates the Authentication, Storage Account, Azure Container, and Azure folder fields.

• Google Cloud Storage. Activates the Authentication, Google Cloud Storage (GCS) Bucket, and Google Cloud Storage (GCS) Folder fields.

Default value: None

Example: S3, Azure, Google Cloud Storage

Authentication

Source Location is S3, Azure, or Google Cloud Storage

Select the authentication method to use for accessing the source data.

Available options are:

• Source Location Credentials. Select this option when you do not have a storage integration setup in your S3 or Azure data storage. Activates the Access Key and Secret Key fields for S3 or the SAS Token field for Azure.

• Source Location Session Credentials. Select this option if you have session credentials to access the source location in S3. Activates the Session Access Key, Session Secret Key, and Session Token fields.

• Storage Integration. Select this option when you want to use the storage integration to access the selected source location. Activates the Storage Integration Name field.

Default value: Source Location Credentials for S3 and Azure, Storage Integration for Google Cloud Storage.

Example: Storage Integration

Storage Integration Name

Source Location is S3, Azure, or Google Cloud Storage and Authentication is Storage Integration.

Enter the name of the storage integration in your Snowflake database. Navigate to one of the following links for more information on setting up your Storage Integration in Snowflake.

• Snowflake Storage Integration for AWS S3

• Snowflake Storage Integration for Azure

• Snowflake Storage Integration for Google Cloud Storage

Default value: N/A

Example: my_s3_integration, my_azure_integration, my_sf_gcs_integration

Access Key

Source Location is S3 and Authentication is
Source Location Credentials.

Enter the access key ID associated with your AWS S3 account.

Default value: N/A

Example: ABCDEFGHIJKL1MNOPQRS