Apply Kafka Connect Single Message Transforms for field renaming, value filtering, and topic routing in a Debezium pipeline

Steps

1. Add transforms to the connector config JSON: set transforms=unwrap,route and define each transform's type and config keys.
2. Apply ExtractNewRecordState to flatten Debezium envelope: transforms.unwrap.type=io.debezium.transforms.ExtractNewRecordState with transforms.unwrap.drop.tombstones=false and transforms.unwrap.delete.handling.mode=rewrite.
3. Apply ReplaceField to rename or filter columns: transforms.rename.type=org.apache.kafka.connect.transforms.ReplaceField$Value, transforms.rename.renames=old_name:new_name, transforms.rename.blacklist=sensitive_column.
4. Apply RegexRouter to dynamically rename output topics: transforms.route.type=org.apache.kafka.connect.transforms.RegexRouter, transforms.route.regex=(.*)orders(.*), transforms.route.replacement=$1order_events$2.
5. Deploy the updated connector config via PUT /connectors/{name}/config and verify the transformed events on the output topic with a CLI consumer.