I have a Debezium connector that pulls data from SQL server tables.
It seems the connector creates the topic name like Server.Database.Table.
I want Server.Database.invitation.Sent.V1 - to be transformed to invitation.Sent.V2
where invitation.Sent.V1 is the table name
Is there a Transform to apply where I can
- remove Server.Database
- replace V1 with V2
in all topics being generated