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

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

    XMLWordPrintable

Details

    Description

      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",

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: