Data engineering·Moving data out of the source
the row is gone from the source and still in the warehouse, because your incremental load can only see rows that exist.
Hard delete detection
Also calledmissing-row detection, delete reconciliation
Working out what the source deleted, when your extraction method can only observe what is present. Query-based extraction cannot do it directly, so teams fall back to a periodic key-set comparison, a soft-delete flag negotiated with the source team, or moving to log-based capture. It is worth naming because it is nearly always discovered late, by an auditor or a privacy request rather than by a test.