The DB history topics need to have "indefinite" retention time essentially. We should check upon connector start-up time and raise a warning or even error message if the topic is configured incorrectly, e.g.:
- retention < 5 years
- compaction enabled
- more than one partion etc.
Might even be done async, so to not impact start-up time.