Snowflake Connection

Access level: read, write

This connection enables access to data that is hosted in Snowflake Data Cloud. Connections are secured with user name / password, private key, or token authentication methods. Snowflake connection is a premium connection that requires a separate license.

Jedox 2023.4 and later support OAuth authentication for Snowflake connections. To enable token authentication, your Integrator project will need an OAuthToken Connection in addition to the Snowflake connection. Details on configuring OAuth on the Snowflake side can be found here.

Connection settings

Host

The URL connection string provided by Snowflake.

Method
  • User name and password for the connection to the Snowflake database
  • Private key (configured in Snowflake)
  • Token: an existing OAuth Token connection
Role Available roles as defined by the Snowflake system
Warehouse Available warehouses in the Snowflake system
Database Available databases for the selected user and role

Additional JDBC parameters must be part of the connection URL. Make sure you use the correct separator: ; or &. Parameters entered here will be added to the connection URL with the correct separators.

Using Snowflake connection and JDBC - Snowflake connection can cause a difference in the extracts of the same time data, as each connection type uses a different format for the query result set (relational extract). The JDBC connection uses JSON as the result format, while the native Snowflake connector uses the default Arrow format.