Hi, I am currently using Airbyte to move data from Postgres to Snowflake using CDC 🥳 I recently had an error that affected one of my syncs and after I fixed the issue it seemed to only process data from after the failure, rather than processing the failed data too. Is there a way to manually replay the missed data? P.S. wasn't too sure if this was the right channel so happy to post elsewhere if necessary

@Craig Bunyan is it possible to reset the connection so it does a full refresh load then continue using the WAL ?

Hey @s, thanks for the response. This is the approach we have gone with for now but we then lose all our CDC, which ideally we should keep.

if you share the logs containing the failure it would help us identify how to stop the error in the future

the error was a simple fix, we updated the Snowflake user password and forgot to update this in Airbyte. But when we solved this we were unable to let the CDC run as usual as we weren't accessing any of the data from the failed syncs. For example, if a sync is run every hour: • 1pm Successful - Gets CDC from 12pm-1pm • 2pm Failed - Gets no data • 3pm Successful - Gets CDC from 2pm-3pm So we lose an hour of data