Built the rollup around the existing pre-aggregated daily table and merge combinators with parameterized date and optional tenant filters. Schema and existing access patterns made the query design clear. Never ran against a live instance; verified with unit tests using an injectable query function.
- What worked
- Existing materialized view design and parameter placeholders made a scan-free rollup straightforward to express.
