Only Incremental records capture using debezium connector for sqlserver

[Prince Parekh]

Hi Team,

Currently, we are using the configuration transforms.unwrap.drop.tombstones: "true" across all our connectors. Moving forward, our goal is to process only the actual column data, without including the "before" and "after" states of the records. 

To achieve this, we plan to modify the relevant parameters so that only incremental records are processed, reflecting the new schema.

I can only see 3 snapshot mode initial,initial_only,no_data for our usecase non of them seems to help.

Is this possible to get the only the incremental record.

Thanks & Regards

Dhruvil.

[Chris Cranford]

Hi -

Debezium's event structure is opinionated and always contains the "Envelope" that wraps the "before", "after", and "source" nested blocks. This behavior can only be adjusted using a Kafka `Transformation`. In your case, you're already approaching this using the recommended approach with the `ExtractNewRecordState`, which flattened the envelope-based structure into a simple single-depth key/value pair of column name/value fields.

-cc

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/0f79a4a0-71da-458a-baab-318a3b36c174n%40googlegroups.com.