Author here: I wrote out some worked examples about how ClickHouse's table engines affect how CDC updates and deletes are treated (on initial write, and on merge), coming to the conclusion that the ReplacingMergeTree is the goldilocks table engine for most CDC use-cases.