Connect your Snowflake warehouse to Optimizely Analytics

  • Updated

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 to Optimizely Analytics.

  2. Click Data > Connections > + New Connection > Snowflake.

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

      • 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

        sf-newflow-2.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.

      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

  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

  7. Click Save. Analytics saves and enables the connection by default.