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 .
You must proceed as follows:
- Go to the Snowflake documentation page and download the jar file from the 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.
drivers that are required to use the Snowflake database are bundled with the software and no additional preparations are required.
Advanced Connection Configuration for Snowflake
The Advanced Connection Setup is used for Snowflake configurations.
To make the Connection String text area and the Notification Service text field appear, select the Advanced Connection Setup radio button. The Username, Password and Database Type fields will remain.
| Setting | Description | ||
|---|---|---|---|
Connection String | In this field you should enter the following string:
| ||
Notification Service | This field is not applicable for the Snowflake db. |