I am using Confluent CDC Connector for Oracle DB. We have a redo log topic and we have FULL SUPPLEMENTAL LOGGING enabled for Oracle tables.
Our connector was pushing records into table specific topic till yesterday when schema for certain topics is changed as requirements grew. The required redo-log-topic could see the DDLs for schema changes as well. We are using dictionary mode: auto, however,
Puzzle is that even though our table specific topic is getting data but new column is not showing up within table specific data in table specific topic. Topics are configured for BACKWARD compat and using AVRO schemas.
Is there way to upgrade schemas without removing underlying topic and all previous versions?
Thank you.