Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-2422

Enable the use of column.whitelist in the SQL Server Connector Configuration


    • Icon: Enhancement Enhancement
    • Resolution: Obsolete
    • Icon: Minor Minor
    • None
    • 1.3.0.Alpha1
    • sqlserver-connector
    • None

      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.

            Unassigned Unassigned
            j.mcmichael Jordan McMichael (Inactive)
            0 Vote for this issue
            2 Start watching this issue