RDBMS providers: Snowflake

Overview

Connects to a Snowflake database.

You need a Snowflake account and credentials.
Snowflake JDBC driver:
- Next generation provider: JDBC drivers are included in the RPDM installer package. The latest installer packages will include the latest tested and approved JDBC drivers; contact Redpoint Support before attempting to update the JDBC drivers that ship with Data Management’s next-generation data providers.
- Legacy provider: You must download the latest Snowflake JDBC driver (version 3.14.1 or above) from the Maven Central Repository and install it.

Redpoint Data Management v9.6.1 introduces a next-generation set of database providers, including Snowflake (with bulk load and bulk query support). These next-generation data providers were rewritten to be more robust and performant.

Next-generation provider features: Refer to RDBMS database providers for additional information.
Connection options: Refer to Configure RDBMS connection options for information about setting options for both next-generation and legacy database providers.
Schemas: Refer to RDBMS schemas for information about schemas for both next-generation and legacy database providers.

Database name	Database API	Reconnect option available
new in v9.6.1 Snowflake (next-gen)	JDBC	No.
Snowflake	JDBC	No.
Snowflake Bulk	JDBC	No. If you specify this provider, you may optionally configure additional properties.

Database name

Database API

Reconnect option available

new in v9.6.1

Snowflake (next-gen)

JDBC

No.

Snowflake

JDBC

No.

Snowflake Bulk

JDBC

No. If you specify this provider, you may optionally configure additional properties.

Snowflake authentication

The legacy Snowflake providers specify the authentication method using the Authenticator attribute, while the next-generation providers specify the authentication method using the Security type attribute.

Data Management supports the following Snowflake authentication methods:

Authentication method	Description
Default	The default authentication method (called “Snowflake internal authenticator” for the legacy Snowflake provider).
Single Sign On (SSO) and Federated Authentication via Okta	To use this functionality: Establish an Okta account. Obtain an Okta authentication URL. Enter the Okta authentication URL (of the form `https://your-okta-account-name.okta.com/`) as Authenticator in your Snowflake data connection.
Service user	new in 9.5.3 Support for Snowflake `SERVICE` user `TYPE` to improve the security of non-interactive (i.e., service) use cases. When Service user is selected, the Private key attribute must be set to the private portion of the service user’s RSA key-pair. Private key is only applicable for the Service user authentication method. The Private key cannot contain carriage returns or line feeds. In addition, leading or trailing spaces are not recommended. This authentication method does not use the Password attribute. Refer to Snowflake Documentation: Create User for more information.

Authentication method

Description

Default

The default authentication method (called “Snowflake internal authenticator” for the legacy Snowflake provider).

Single Sign On (SSO) and Federated Authentication via Okta

To use this functionality:

Establish an Okta account.
Obtain an Okta authentication URL.
Enter the Okta authentication URL (of the form https://your-okta-account-name.okta.com/) as Authenticator in your Snowflake data connection.

Service user

new in 9.5.3

Support for Snowflake SERVICE user TYPE to improve the security of non-interactive (i.e., service) use cases.

When Service user is selected, the Private key attribute must be set to the private portion of the service user’s RSA key-pair.

Private key is only applicable for the Service user authentication method.
The Private key cannot contain carriage returns or line feeds. In addition, leading or trailing spaces are not recommended.

This authentication method does not use the Password attribute.

Refer to Snowflake Documentation: Create User for more information.