Debezium JSON payload example

orders_debezium.json

{
    "before": null,
    "after":
    {
        "O_ORDERKEY": 2,
        "O_CUSTKEY": 78002,
        "O_ORDERSTATUS": "O",
        "O_TOTALPRICE": "46929.18",
        "O_ORDERDATE": "1996-12-01",
        "O_ORDERPRIORITY": "1-URGENT",
        "O_CLERK": "Clerk#000000880",
        "O_SHIPPRIORITY": 0,
        "O_COMMENT": " foxes. pending accounts at the pending, silent asymptot"
    },
    "source":
    {
        "version": "1.9.7.Final",
        "connector": "mysql",
        "name": "RW_CDC_1002",
        "ts_ms": 1695277757000,
        "snapshot": "true",
        "db": "mydb",
        "sequence": null,
        "table": "orders_new",
        "server_id": 0,
        "gtid": null,
        "file": "binlog.000008",
        "pos": 3693,
        "row": 0,
        "thread": null,
        "query": null
    },
    "op": "r",
    "ts_ms": 1695277757016,
    "transaction": null
}