Change Data Capture

A pipeline can keep a warehouse copy of an application's table by copying the whole table on every run. Most of those rows, however, have not changed since the previous run. The other way is to find only the rows that were inserted, updated, or deleted, and to pass them on as a list of changes. That method is called change data capture (CDC).

**Change data capture is a method that records each insert, update, and delete on a source table and delivers those changes to another system