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

db, schema and table field are not available in value payload

XMLWordPrintable

      The "source" section of the value message does not contain " database, schema and table where the change happened" as specified in the SQL Server Connector documentation:

      https://debezium.io/docs/connectors/sqlserver/#schema_change_topic

      Here's what I get:

      "source":

      { "version": "0.9.5.Final", "connector": "sqlserver", "name": "localhost", "ts_ms": 1564501900103, "change_lsn": "000000aa:000249e0:0002", "commit_lsn": "000000aa:000249e0:0003", "snapshot": false }

      ,

      I'm using a the Route transformer to send all messages to just one Kafka Topic:

      "transforms": "Reroute",
      "transforms.Reroute.type": "io.debezium.transforms.ByLogicalTableRouter",
      "transforms.Reroute.topic.regex": "(.)dbo(.)",
      "transforms.Reroute.topic.replacement": "tpch",

              Unassigned Unassigned
              davide.mauri Davide Mauri (Inactive)
              Davide Mauri Davide Mauri (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: