🛡️Data Reconciliation
Also known as Data Recon, Source-to-Target Reconciliation, Row Count Check
Checking that copied data still matches its source. You compare counts and totals.
Think of it like
It is like counting your change after you shop. The receipt and your purse must match.
Example
The shop database shows 1,204 orders last night, but the warehouse has 1,192. The check fails and the load is held back. Emma finds 12 orders stuck on a bad date.
Why it matters
A pipeline can finish green and still drop rows. Only a check against the source shows it.
Definition
Example code
sql
SELECT COUNT(*), SUM(total) FROM orders
WHERE order_date = '2026-11-15';
-- source: 1204 | 52300
-- warehouse: 1192 | 51780Common mistake
Key takeaways
- 1Two sides. The source against the copy.
- 2Counts and sums. Rows first, then totals.
- 3Before anyone reads. Hold the data until it matches.