Connecting to Data Sources

Welcome​

Welcome to the Data Source Connection module. In this section, you'll learn how to establish secure connections between Optimizely Analytics and your cloud data warehouse. These connections are the foundation that allow Analytics to run queries and deliver insights from your raw data in real time.​

By the end of this module, you will be able to:​

• Understand what a data source connection is and how it works within Analytics.​

• Identify which cloud warehouses are supported.​

• Create and manage data connections from the application setup or directly from the Catalog.​

• Delete unused or outdated connections when necessary.

What is a Connection?​

A connection acts as a secure data pipe between Optimizely Analytics and your data warehouse. It enables Analytics to issue live queries directly against your warehouse, so your data stays where it is—no duplication or syncing required.​

You can configure these connections as part of your application setup or later via the Catalog. Once established, they form the backbone of every dataset, query, and exploration in Analytics.​​

Supported Warehouses​

Optimizely Analytics currently supports the following data warehouse connections:​

• Snowflake​: How to connect to Snowflake​

• BigQuery​: How to connect to BigQuery​

• Amazon Redshift​: How to connect to Redshift​

• Databricks​: How to connect to Databricks​

​Create a Connection​

You can create a connection during the initial setup of your Analytics application or at any time from the Catalog.​

​Follow this step-by-step demo to create a new connection to your warehouse: https://optimizely.navattic.com/teh0xe2.​

Here’s how to create a connection from the Catalog for more flexibility and control: https://optimizely.navattic.com/q6h0kk5.​

Delete a Connection​

Watch how to safely delete a connection: https://optimizely.navattic.com/6ok0v8s.​