Suppose the CDC origin detects a change in the table and captures it, and the pipeline is processing the data, if for some reason the data is being processed very slowly and you want to reset the origin and also delete the change it captured how will one do it ?
I have noticed that even if I stop the pipeline and start it again by saying reset origin and start it still has the change it captured earlier and starts processing it again. So I wanted to know a way to delete that change which it captured earlier in the previous run.