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.

Snowflake authentication

The legacy Snowflake providers specify the authentication method using the Authenticator attribute, while the authentication method is integral to the next-generation providers: that is, there are distinct providers for Snowflake’s Internal, Okta, and Service user authentication methods.

Data Management supports the following Snowflake authentication methods:

Authentication method

Description

Snowflake internal authenticator

The default authentication method.

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.6.1

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.