Feature request or enhancement

For feature requests or enhancements, provide this information, please:

Which use case/requirement will be addressed by the proposed feature?

Currently there is no mechanism in place that would let the database know when it's safe to delete a capture instance. The database has to guess this somehow on it's own. The connector could emit a notification when it has finished reading from a capture instance so that some mechanism downstream could delete the capture instance after receiving such notification.

Implementation ideas (optional)

Once the connector has finished reading from a capture instance and has committed the offset emit a notification that would let the subscribers know that the capture instance has been read completely.

Here is the patch we came up with at SugarCRM: https://github.com/debezium/debezium/pull/4939.