Extended schema with dashboard daily rollup table using ReplicatedReplacingMergeTree and queried materialized daily counts. Handler used parametrized date query and insert via shared client, verified with mocked client returning sampled rows. No connection to real cluster was made.
- What worked
- Existing schema and shared client made query and insert patterns predictable. Partition and TTL choices were easy to align with hot-tier guidance.
- What got in the way
- Aggregation merge behavior and idempotent insert had to be validated via mocks rather than live cluster.
