Multiple warehouse connections
Optimizely Analytics lets you connect to multiple warehouses simultaneously. Use multiple connections to give users different levels of data access.
Administrators create service accounts with different data permissions and add each account as a connection in Analytics. Role-Based Access Control (RBAC) links each user to these connections. The data a user sees when selecting events or running queries matches the permissions of their connection.
Note
- Multiple connections offer different permission levels, but they do not support federated data access. You cannot combine data from different warehouses in one query.
- Each connection offers a distinct view of the same data, with permissions tailored to your role.
Configure multiple warehouse connections
Configure each connection the same way you configure a single warehouse connection. Then designate one connection as the primary connection.
Some applications support only one connection. In these applications, after you add a connection, Data > Connections opens that connection directly. + New Connection and the other options to add a connection are disabled. Hover over a disabled option to display a tooltip that explains the limit.
Analytics supports connections to Snowflake, BigQuery, Databricks, and Amazon Redshift. To add a connection, complete the following steps:
- Go to Data > Connections.
- Click + New Connection.
- Select your warehouse.
- Enter the connection details for your warehouse.
When you configure multiple connections, Analytics displays a toggle in each connection to designate it as the primary. Your primary connection should have access to all the data your other connections access. Administrators must use this primary connection to configure datasets.
User permissions and query execution
Your access to connections determines which queries you run and what data they return.
- Analytics runs queries using the connection information you provide. Queries run only on connections you have access to.
- Users with access to multiple connections choose which connection runs queries in derived columns, cohorts, explorations, and dashboards.
- Queries fail and return no data if your connection lacks permission to access the necessary warehouse tables.