Wagner Ricardo
unread,Nov 27, 2024, 10:06:30 AMNov 27Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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?