A CDC stream groups changes mapped from table partitions and provides their reading order. Multiple partitions can share one stream ID, so query one stream at a time. section 12.1.2
Use CDC streams with these rules:
- Treat CDC rows as changes over time, not complete row states; reconstruct a row by ingesting its changes. section 12.1.2
- Expect a partition key to map consistently to one stream ID within a generation, while many partition keys may share that stream. section 12.1.2
- Account for topology changes by finding the current generation, retrieving its stream IDs, and querying each stream. section 12.1.2
Tracking an author change
After inserting Charlie Change and updating only the bio, the CDC log records an initial row and a later change with name set to null. The log therefore captures changed values rather than the author's final state.
