Suppose that I want to set up a Kafka source connector to pump some data from my DB into my Kafka. Now, suppose that due to security reasons I want to obfuscate (say, apply a hash function) to some of the columns in my DB. Is there a standard way to to that with Kafka Connect, or do I have to first create private topics and then write some custom code to create public versions of those topics (with hashed values for sensitive data)?
I know that there's such thing as transformations (MaskField, etc.), but none of them seems to solve my problem. For example, MaskField does something like +1-234-567-8987 -> "--****", which I do not want to happen, because I still want to have distinct entries for different input values.