Multiple warehouse connections
Optimizely Analytics lets you connect to multiple warehouses simultaneously. Enabling multiple connections lets you specify different access roles. If you are an administrator, you can create service accounts with varying data permissions and add them as connections in Optimizely Analytics. Role-Based Access Control (RBAC) links you to these connections, ensuring that your data view aligns with the assigned permissions. That is, the data you access when selecting events or running queries corresponds to the permissions you have.
Note
- While multiple connections offer different permission levels, they do not enable federated data access across warehouses.
- Each connection offers a distinct view of the same data, with permissions tailored to your role.
Configure multiple warehouse connections
When setting up multiple connections, follow the same process as for a single warehouse, but also select a primary connection.
Click Data > Connections > + New Connection and select a warehouse. Optimizely Analytics supports connections to Snowflake, BigQuery, Databricks, and Amazon Redshift.
When you configure multiple connections, Optimizely Analytics displays a toggle in each connection to designate it as the primary. Your primary connection should be a superset of the other connections you create. Administrators must use this primary connection to configure datasets.
User permissions and query execution
- Optimizely Analytics runs queries based on the connection information you provide. You can only run queries on connections you have access to.
- If you have access to multiple connections, you can choose the specific connection for running 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.