Skip to content
Vol. I · No. 251
Mon · 8 Jun
A Daily Lexicon of Trustworthy Data
The Lexicon

005·75

change data capture

/tʃeɪndʒ ˈdeɪ.tə ˈkæp.tʃər/ - n.

1 [colloq.] Capturing every change the source makes, including the ones it would prefer you had not noticed.Keep. Punchy.This is the problem.

Working definition

2. A technique that detects and propagates row-level changes from a source database, usually by reading its transaction log, rather than re-copying full tables.

Promoted
Seen in the wild · 1
See also
  • incremental loadProcessing only what changed, defined by a watermark everyone trusts and no one can explain.
  • ingestionAccepting whatever a source sends, on the working theory that the schema it sent last week is the schema it will send today.
  • late-arriving dataData that shows up after the meeting that needed it, with a perfectly good explanation no one waited to hear.