This section contains information that is specific to the database type Snowflake.
Supported Functions
The Snowflake Server database can be used with:
- sqlExec Function (APL)
- SQL Collection/Forwarding Agents
Preparations
The Snowflake driver has to be downloaded to the Platform in order to connect to a Snowflake database from .
...
- Go to the Snowflake documentation page and download the jar file from the maven Maven repository:
https://docs.snowflake.com/en/user-guide/jdbc-download.html - Place the downloaded jar file in the
$MZ_HOME/3pp directory. - Restart the Platform and EC/ECSAs for the change to take effect.
Advanced Connection Configuration for Snowflake
The Advanced Connection Setup is used for Snowflake configurations.
...
| Setting | Description | ||
|---|---|---|---|
Connection String | In this field, you should enter the following string:
| ||
Notification Service | This field is not applicable to the Snowflake database. |
| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||