Configure your Snowflake warehouse

  • Updated
  1. Click Data > Connections > + New Connection > Snowflake.

    opti-snowflake-1.png

  2. Name your connection, add a description, and choose a folder.

  3. Configure the required fields for the Snowflake connection. You can specify separate warehouses for sampled and unsampled queries to optimize performance and cost. These warehouses must exist in your Snowflake account.

    • Account URL – JDBC formatted URL or any standard format URL associated with your Snowflake account. For example, jdbc:snowflake ://ACCOUNT_ID.snowflakecomputing.com. You can find your Snowflake account ID in the URL of your Snowflake application.
    • Username – Snowflake account username.
    • Authentication mode – Connection authentication mode. There are two options – Simple Authentication and Key-Pair Authentication. 
      • Simple authentication requires you to authenticate your connection with the Snowflake account password.

        opti-snowflake-2.png

      • Key-Pair authentication requires you to generate a read-only public key. If you want to regenerate a new key-pair and replace the old one, click Generate new Key-Pair.
      • One of your Snowflake admins must update this user in your Snowflake account to set the generated public key as RSA_PUBLIC_KEY. Read more about Key-Pair authentication.

        opti-snowflake-3.png

    • (Optional) Warehouse – Name of the default warehouse allocated to Analytics
    • (Optional ) Sampling warehouse – Name of the warehouse allocated to Analytics for sampling query execution. 
  4. Click refresh on the Health to validate the connection. If the configuration is successful, the icon turns green and displays Good.

    opti-snowflake-4.png

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