---
title: "Connecting to Snowflake"
---

# Connecting to Snowflake

> 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](../jdbc-drivers-and-translators/jdbc-driver-and-database-translator-settings.md#snowflake-default-jdbc-driver-settings) page for more information on configuring the Snowflake driver and translator settings.

## Snowflake Connection Requirements

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

    ![](sf-Databases-Connections.png)

3. Click **Create new Database Connection...** on the Database Connections page
4. Select **Snowflake** and click **Next**.

    ![](sf-add.png)

5. Enter a name for your connection.
6. Enter the the connect URL for the database.
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.

:::info Ignition Exchange Resource Solution
The Ignition Exchange has a [Perspective Snowflake Dashboard](https://inductiveautomation.com/exchange/2641/overview) 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](https://cirrus-link.com/iot-bridge-for-snowflake/) to provide the easily deployable solution when connecting to Snowflake. Refer to the [Cirrus Link documentation](https://docs.chariot.io/display/CLD80/Snowflake+Tools) for more information on how this architecture is connected and related Snowflake tools.  
:::