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

Add SMT implementation for Topic routing based on `op` field

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Won't Do
    • Icon: Minor Minor
    • None
    • 0.9.5.Final
    • connect-service
    • None

      Background
      Currently we have two types of transformation for topic routing: ByLogicalTableRouter and EventRouter. ByLogicalTableRouter enables you to reroute the topic using a regular expression for the current topic and EventRouter enables you to reroute the topic based on the outbox table fields.

      I would like to have a possibility to have a topic which includes type of operation (INSERT, UPDATE or DELETE). So if the op is u then topic should be myserver.mydb.customers.update and so on.

      Improvement Proposal
      This could be solved by having another transformation ByOperationTypeRouter, which combines current topic name and op field.

      Benefits of Doing This
      Possibility to scale consumers based on type of operation made on a certain table.

      NOTE: I'm new to debezium, and I've checked all types of transformations and I couldn't find one (or combinations) that could provide me with the result I've stated.

              Unassigned Unassigned
              stevan.milic Stevan Milic (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: