79578867

Date: 2025-04-17 09:09:17
Score: 1
Natty:
Report link

By adding

{
  ...
  "converters": "tinyint-one-to-boolean,jdbc-sink,duration-converter",
  "tinyint-one-to-boolean.type": "io.debezium.connector.binlog.converters.TinyIntOneToBooleanConverter",
  "tinyint-one-to-boolean.length.checker": "false",
  "jdbc-sink.type": "io.debezium.connector.binlog.converters.JdbcSinkDataTypesConverter",
  "tinyint-one-to-boolean.selector": "my_database.my_table.my_column,my_database.my_table.other_column",
  "jdbc-sink.selector.boolean": "my_database.my_table.my_column,my_database.my_table.other_column",
  ...
}

to my source connector config I was able to replicate the tinyint as boolean in PostgreSQL.

see also https://debezium.io/documentation/reference/stable/connectors/mysql.html#_tinyint1_to_boolean

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: HarryKane