Add pre-aggregated reporting rollups with write path and backfill
Add pre-aggregated reporting rollups with write path and backfill: a task in bird-critic-1.5-full-300 (Harbor dataset). Chatwoot's reporting stack queries reporting events directly, which slows down as tables grow. This task introduces a reporting events rollups table that stores pre-aggregated…
The task
Chatwoot's reporting stack queries `reporting_events` directly, which slows down as tables grow. This task introduces a `reporting_events_rollups` table that stores pre-aggregated daily per-metric, per-dimension totals. The write path is activated when an account's `reporting_timezone` is set (a new IANA-validated…
Part of kochsnow/bird-critic-1.5-full-300.