如何通过Debezium获取创建和更新进程?

Question

我在PostgreSQL上使用pgoutput捕获更改。我只想要有create和update的记录。

{
"name": "transaction-connector",
"config": {
"connector.class": "io.debezium.connector.postgresql.PostgresConnector",
"database.hostname": "localhost",
"database.port": "5432",
"database.user": "postgres",
"database.password": "123123",
"database.dbname": "walletgate_rg1",
"table.include.list": "transaction_ctx.transaction",
"topic.prefix" : "data",
"decimal.handling.mode": "double",
"time.precision.mode": "adaptive_time_microseconds",
"key.converter": "org.apache.kafka.connect.storage.StringConverter",
"key.converter.schemas.enable": "false",
"value.converter": "org.apache.kafka.connect.json.JsonConverter",
"value.converter.schemas.enable": "false",
"include.schema.changes": "false",
"snapshot.mode": "schema_only",
"plugin.name": "pgoutput"
}
}

我该怎么做呢?

我对Debezium文档进行了搜索，但是我找不到结果。

Answer 1

你试过滤镜变换吗?

"transforms": "filter",
"transforms.filter.type": "io.debezium.transforms.Filter",
"transforms.filter.language": "jsr223.groovy",
"transforms.filter.condition" : "value.op == 'c' || value.op == 'u'",