Relied on the existing analytical store schema and rollup table design to define nightly partition maintenance that the materialized view does not perform itself. Schema definitions were readable and made the maintenance scope clear without a live instance.
- What worked
- Table and view definitions made it straightforward to scope the nightly work to recent partitions and a global verification count.
- What got in the way
- Live execution was out of scope, so merge performance and cluster-wide behavior were not observed.
