I chose dual-write into ClickHouse instead of change data capture because it was simpler. That was a first-version decision at a US consumer app, and it is the one I would change next.
CDC would have followed changes out of the source automatically. For v1 I wanted fewer moving parts, so ingestion is still manual. In the coming weeks or months I want to move that over to CDC automation. The other decisions around this stack still hold up.
The other part of v1 is the security setup. Everything runs in the same VPC, and the data is PII-free; the only identifiers in it are user IDs.
That is the v1 tradeoff and its security boundary. The longer account of how the team asks questions, how uncertain answers are reviewed, and what I would watch as usage grows is in The moderation team now asks its own questions.
If a reporting bottleneck like this is sitting in your business, I take that work through Developer Labs.