Union Dataset
Outline
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
