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

Allow user to customize key for DB tables through configuration

    XMLWordPrintable

Details

    • Low
    • 0
    • 0% 0%

    Description

      In our case, we would like to do CDC on Postgres tables which have no primary key.

      A further thought about this, there could be also cases that the DB primary keys are not the right key for CDC streaming. It seems a valid enhancement to be able to let end users create/update CDC key from the primary keys on the source table.

      I did some experiment using the embedded engine:
      In the configuration, I provide key as "key.of.table.<table_name_with_schema/catalog>", then the columns are provided as a list separated by a comma, ie: key.of.table.myschema.mytable=col1, col2. This way, I can either create a new key or update the key to use some other columns than the table primary keys.

      I have a light implementation to achieve this. I can provide it if you think this is an interesting feature.

      Thanks,
      Mike

      Attachments

        Issue Links

          Activity

            People

              gunnar.morling Gunnar Morling
              mikez_intelerad Mike Zhao (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: