Extract only payload SqlServer

13 views
Skip to first unread message

Wagner Ricardo

unread,
Nov 27, 2024, 10:06:30 AMNov 27
to debezium
I was testing version 3.0.0.Final and I was able to extract only the payload data for PostgreSQL, using:
debezium.transforms.unwrap.type=io.debezium.transforms.ExtractNewRecordState
debezium.transforms.unwrap.add.headers=operation
debezium.transforms.unwrap.drop.tombstones=true
debezium.transforms.unwrap.delete.handling.mode=none

However, when migrating to SQL Server, it seems to have no effect, coming AFTER, but with the schema:
{"schema":{"type":"struct","fields":[{"type":"string","optional":false,"field":......"payload":{"COMPANY":"01",...}}

Does anyone know how this can be solved, to only have what is inside? of the payload object?

Nathan Smit

unread,
Nov 27, 2024, 4:17:38 PMNov 27
to debezium
Just to make extra sure, you have unwrap as one of your transforms right?  This is what we do with Oracle/Mysql as a source which works fine but yeah don't see anything obviously wrong in your config :/

debezium.transforms=unwrap
debezium.transforms.unwrap.type=io.debezium.transforms.ExtractNewRecordState
debezium.transforms.unwrap.drop.tombstones=true
debezium.transforms.unwrap.delete.handling.mode=rewrite
debezium.transforms.unwrap.add.fields=op:operation



Reply all
Reply to author
Forward
Message has been deleted
0 new messages