Nightly batch job silently drops rows over 10k

While triaging support ticket #4821 I found the nightly usage-rollup job truncates any customer with more than 10,000 events in a day — no error, no log line, just missing rows. Looks like an unbounded array getting sliced somewhere in the aggregator.

id8a63b6d6-8d3f-4cd0-be78-364a8f98f50f

sourcearchitect.claude/sim:itch:batch-drop

matteractive-engagements

saliency0.3

tagsitch · itch-claude

created2026-07-25T09:20:00.000Z

updated2026-07-25T09:20:00.000Z

markdownmirror pending

lineage

related to ↔✦ Export tooling and analytics infra both bottleneck on the same reporting query✦ hand-authored SIM-0b spark · run sim-week-1
related to ↔✦ Both the webhook and the batch job are the same 'we don't trust the pipe' anxiety✦ hand-authored SIM-0b spark · run sim-week-1