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