Snowflake

You can create Snowflake environment by providing the necessary connection parameters.

Before creating a Snowflake environment, you should take a note of the following:

  • Prerequisites
  • JDBC driver details
  • TLS connection details
  • JDBC connection parameters

Prerequisites

Prerequisite steps for establishing successful connection:

  • Creation of dedicated service account for erwin with Metadata read-only privileges in Snowflake database
  • Snowflake Database ports 443 and 80 should be opened via firewall to accept connections from erwin DI Suite application server

JDBC Driver Details

Currently Snowflake JDBC driver is not packaged with erwin DI Suite application. Download the Snowflake JDBC driver here.

Once downloaded, place the snowflake drivers at the following location on the erwin DI Suite application server:

\Apache Software Foundation\<Tomcat X.X>\webapps\erwinDISuite\WEB-INF\lib

TLS Connection Details

  • The Snowflake packaged JDBC driver version 3.1.X and above implement TLS v1.2 providing the latest security patches on the protocol. So, you will not need to set any additional properties. The connection will use TLS 1.2 encryption by default.
  • Add SSL Parameter in Connection String (if required): 
    jdbc:snowflake://<accountname>.snowflakecomputing.com/
    ?warehouse=DataWarehouseName&db=DatabaseName&schema=
    SchemaName&ssl=on

JDBC Connection Parameters

To enter Snowflake connection parameters, follow these steps:

  1. Select Database Type as Snowflake while creating the environment.

    2. The following connection parameters appear on the right hand side.

  2. Enter appropriate values in the fields (connection parameters). The fields marked with a red asterisk are mandatory.

    Field Name

    Description

    Driver Name

    Specifies the JDBC driver name for connecting to the database.

    For example, com.snowflake.client.jdbc.SnowflakeDriver

    DBMS Name/DSN

    Enter the Snowflake database name.

    For example, AW2012_DV.

    IP Address/Host Name

    Enter <accountname>.snowflakecomputing.com

    For example, analytixds.us-east-1.snowflakecomputing.com

    Port

    Specifies the port to connect with the database.

    443 is the default port for the Snowflake database. You can change it, if required.

    User Name

    Enter the Snowflake (Service account) user name.

    For example, shawn.

    Password

    Enter the Snowflake (Service account) password.

    For example, goerwin@1.

    URL

    Specifies the full JDBC URL that is used to establish a connection with the database.

    It is autopopulated based on the other parameters.

    For example,

    jdbc:snowflake://<accountname>.snowflakecomputing.com/
    ?warehouse=DataWarehouseName&db=DatabaseName&
    schema=SchemaName

    DBMS Instance Schema

    Specifies the schema of the database.

    Use this option to select multiple or narrow down to single schema.

    Connection Pool Type

    Specifies the connection pool type being used to connect via JDBC.

    For example, HIKARICP and BONECP.

    Number of Partitions

    Specifies the number of partitions of the database.

    It is autopopulated with default number of partitions. You can edit and provide the number of partitions as desired. For example, 1.

    Minimum Connections Per Partitions

    Specifies the minimum connections per partitions of the database.

    It is autopopulated with default minimum connections per partitions. You can edit and provide the minimum connections per partitions as desired. For example, 3.

    Maximum Connections Per Partitions

    Specifies the maximum connections per partitions of the database.

    It is autopopulated with default maximum connections per partitions. You can edit and provide the maximum connections per partitions as desired. For example, 5.

  3. Click to use database options.

    4. The Database Options page appears displaying the different options available.

  4. Use the database options in the following way:
    Key ()
    To use a key, select the corresponding check box.
    Value
    To set the value of the selected key, double-click the corresponding cell under the Value column and select the appropriate value from the drop down.
    OK ()
    To save the database options, click .