Data engineering·Moving data out of the source
you poll the source every few minutes with a where-clause on updated_at, and a row deleted outright simply stops appearing.
Query-based CDC
Also calledpolling CDC, timestamp-based capture
Capturing changes by repeatedly querying the source for rows whose timestamp or version has moved. It needs nothing but a read connection, which is why it is what you build first and what you can point at a vendor's API. It cannot see hard deletes, it misses intermediate values when a row changes twice between polls, and every poll is real load on a production database — the three reasons teams eventually move to the log.