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

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

    XMLWordPrintable

Details

    • Enhancement
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Out of Date
    • 1.3.0.Alpha1
    • None
    • sqlserver-connector
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: