1
votes

Can we whitelist source columns in kafka connector instead of blacklisting columns? I am using kafka connect with debezium to fetch CDC changes from SQL Server.

1

1 Answers

1
votes

Unfortunately you cannot.

For SQL Server (and any relational connector), the databases, schemas, and tables can all be specified as a whitelist or blacklist configuration setting. Unfortunately columns are only permissible as blacklists.

For MongoDB (non-relational connectors), the databases and collections can all be specified as a whitelist or blacklist configuration setting. Unfortunately fields are only permissible as blacklists.