Help families in GazaDonate to the IRC to provide humanitarian aid and resettlement resources to families in Gaza
JT's Space
Articles
About
Journal
RaW
GitHub
Articles
About
Journal
RaW
GitHub

Wednesday October 29, 2025

JT Houk
Published October 29, 2025
cash-movement-reportdata-pipelinedebugging

Projects

Focused on unblocking the Cash Movement Report. With Vikki out, I took over her frontend tasks and reviewed Kapil's work on the report queries. I also plan to run performance tests on the notes search index and analyze the production table size for cost implications.

Insaf resolved several issues in the CDC streams feeding BigQuery. The retailer_id field needed to be defined as a hydrated field on the register_open_sequence_v1 event. The cash_movement table's type column had to change from tinyint to tinyint(4) so it wouldn't be interpreted as a boolean. The reporting pipeline streams needed updates and a backfill, and null retailer_id values had to be filtered during that backfill.

I created a new task to fix the frontend service's report query, which was incorrectly using the cashMovementTableFormat property instead of the dimension property. I also picked up Vikki's tasks and will merge them tomorrow morning. The export menu integration should already be complete.