Union Dataset

What is a Union Dataset?​

​A union dataset combines multiple tables from the data warehouse into a single logical dataset, making it appear as one unified source to users. This is especially useful when you want to create a single event dataset from several event-specific tables in the warehouse—each representing a different event type.​

​Unlike a source dataset, which maps to just one warehouse table, a union dataset connects to multiple tables. Using union datasets in Analytics offers both performance and cost benefits compared to physically merging the tables within the warehouse.​

​How to create a Union Dataset in Optimizely Analytics​

Explore the demo to learn how to create a Union dataset and understand its various sections used for dataset definition: https://optimizely.navattic.com/3kh80oii

Auto-Monitoring in Union Datasets​

​Auto-monitoring enables you to efficiently manage large sets of tables within a union dataset by automatically detecting changes and additions to source schemas. This feature helps keep your union datasets up to date as new tables are added—minimizing manual updates and maintenance. Instead of loading all tables at once, auto-monitoring adds them gradually in background batches.​

​Watch the demo below to learn how to create an auto-monitored union dataset: https://optimizely.navattic.com/phh80o9l

Updating Regular Union Datasets to Auto-Monitored​

​Converting a regular union dataset into an auto-monitored one requires careful handling to ensure accuracy and consistency throughout the process. Try this demo to learn how to convert and existing union dataset into an auto-monitored one: https://optimizely.navattic.com/g0h80czz