Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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.

You must proceed as follows:

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

  2. Place the downloaded jar file in the $MZ_HOME/3pp directory.

  3. Restart the Platform and ECs for the change to take effect.

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.


Database Profile Configuration - Advanced Connection Setup for Snowflake


SettingDescription

Connection String

In this field you should enter the following string:

jdbc:snowflake:<ip address>/<db query>

Notification Service

This field is not applicable for the Snowflake db.

  • No labels