Row counts and checksums
Counts find rows that went missing. Checksums find values that changed on the way, a truncated decimal or a shifted timestamp, which a count never sees.
Reconcile both per partition, by day or by load, so a mismatch narrows to one slice of history.







