---
title: Connect your Snowflake warehouse to Optimizely Analytics
slug: analytics/docs/connect-your-snowflake-warehouse-to-optimizely-analytics
docTags: 
createdAt: 2026-07-20T15:45:29.946Z
---

Connecting your Snowflake warehouse to Optimizely Analytics lets you seamlessly access and analyze vast amounts of data stored in Snowflake, letting you derive actionable insights and make data-driven decisions.

1. [Log in](docId:1cHv2h5-4d73lsNfP_CYP) to Optimizely Analytics.
2. Click **Data > Connections > + New Connection** **> Snowflake**.

   ![opti-snowflake-1.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/LnpbcWr9xpzW2hbsySbHx-20260720-144829.png)
3. Name your connection, add a description, and choose a folder.
4. Configure the required fields for the Snowflake connection.
   - **Account URL** – Enter the JDBC-formatted URL or any standard-format URL associated with your Snowflake account. For example, `jdbc:snowflake://ACCOUNT_ID.snowflakecomputing.com`. You can [locate your Snowflake account ID](https://docs.snowflake.com/pt/en/user-guide/admin-account-identifier?utm_source=openai) in the URL of your Snowflake application.
   - **Username** – Enter the Snowflake account username.
   - **Authentication mode** – Select your preferred authentication mode.
     - **Simple authentication** – Authenticate your connection with the Snowflake account password.

       ![sf-newflow-1.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/BTopti3QWgYJUey8X5j9I-20260720-144829.png)
     - **Key-Pair authentication** – Generate a read-only public key. To regenerate and replace an old key-pair, click **Generate new Key-Pair**. Snowflake supports multiple active keys, enabling seamless rotation. You can associate up to two public keys with a single user, facilitating uninterrupted key rotation. A Snowflake administrator must execute the command displayed on the connection setup page in the Snowflake SQL CLI to update the Snowflake user with the new public key as *RSA\_PUBLIC\_KEY*. [See Snowflake's Key-Pair authentication](https://docs.snowflake.com/en/user-guide/key-pair-auth#configuring-key-pair-rotation)

       ![sf-newflow-2.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/OW1auzb2UqWc62bwNo-RR-20260720-144829.png)
   - **(Optional) Warehouse Name** – Enter the name of the default warehouse allocated to Analytics.
   - **(Optional) Sampling Warehouse Name** – Enter the name of the warehouse allocated to Analytics for sampling query execution.

     :::hint{type="info"}
     **Note**

     You can specify separate warehouses for sampled and unsampled queries to optimize performance and cost. These warehouses must exist in your Snowflake account.
     :::
5. Click **refresh** on the **Health** to validate the connection. If the configuration is successful, the icon turns green and displays **Good**.

   ![sf-conn-health.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/ir8mkLOq1M4Bu5ZYosNLX-20260720-144829.png)
6. Click **+** within **Advanced options > Parameters** to add non-essential or custom properties as key-value pairs beyond the main configuration parameters. This is an optional step.

   ![conn-1.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/LpH2UlD2JRGLgkM1Pp7qf-20260720-144829.png)
7. Click **Save**. Analytics saves and enables the connection by default.