Skip to main content
Version: 8.1

Connecting to Snowflake

Snowflake Connection Requirements​

In order to connect Ignition to Snowflake you must have a translator, a driver, and a database connection. See the JDBC Driver and Database Translator Settings page for more information on configuring the Snowflake driver and translater settings.

The translator and driver only need to be configured once, then you can make as many connections as you want to any compatible Snowflake database.

note

Query customization may be required when connecting to Snowflake to ensure all native Ignition modules function correctly. For instance, the Alarm tables, Historian tables, and SQL Bridge systems won't work automatically and custom coding is needed to provide the necessary formatting adjustments.

Connect to Snowflake​

  1. On the Gateway Webpage, go to the Config section.

  2. Scroll down to Databases > Connections.

  3. Click Create new Database Connection... on the Database Connections page

  4. Select Snowflake and click Next.

  5. Enter a name for your connection.

  6. Enter the the connect URL for the database. For Snowflake this setting is JDBC-driver specific, so it must lead to a local directory or a locally mapped drive.

  7. Click Create New Database Connection.

Your connection is now created and the Database Connections page is displayed showing the Status of your connection as Valid.

Ignition Exchange Resource Solution

The Ignition Exchange has a Perspective Snowflake Dashboard resource available to download that queries data models and historical data from Snowflake. This resource requires Ignition version 8.1.37, the MQTT Transmission module, a Snowflake Account, and Cirrus Link IoT Bridge to provide the easily deployable solution when connecting to Snowflake. Refer to the Cirrus Link documentation for more information on how this architecture is connected and related Snowflake tools.