Relative Content

Tag Archive for postgresqlapache-kafkaapache-kafka-connectcdcdebezium-connect

ERROR finding table in UPPERCASE schema in Postgres using Kafka with Debezium connectors

I’m working with Kafka and Debezium connectors for CDC events in a PostgreSQL database, where the schema is in uppercase format like “SCHEMA”. The Debezium source connector successfully fetches and inserts data into the Kafka topic. However, when using the Debezium sink connector, it encounters an issue and can’t find the table due to the schema being in uppercase, resulting in an error stating it can’t find schema.table_name.