Currently, the SQL Server connector only supports filtering columns when constructing messages through the use of column.blacklist. The goal of this story is to enable use of column.whitelist in the same context.

The specific use case where this becomes handy is in keeping synchronized with cdc jobs in SQL server, and decoupling connector configuration from table column addition. An available option when configuring CDC on a table is to whitelist the columns that CDC looks at for changes, and when the setting is used, only those fields appear in the internal CDC table, as opposed to showing the entire modified row. By supporting a whitelist, the connector will need to only be reconfigured when new columns are added to CDC, as opposed to when new columns are added to the table.