question

M.C. avatar image
M.C. asked Erick Ramirez answered

Is it possible to produce a Kafka message that includes the before and after CDC values?

Hi,

Looking for an answer to a topic, expecting for something similar to an Oracle GG, need the "before" and "after" image, means record in the table, that has been changed/updated...

Is it possible to produce a message that will be sent to a Kafka topic, that will include both values - "before" and "after"?

Thanks!

astra dbchange data capture
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered

The Change Data Capture (CDC) entry only contains the mutation which is the value being written to the database. It isn't possible to know the value of a cell/column/partition before the mutation is applied because that requires a read-before-write which is not a normal operation in Cassandra. Cheers!

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.