Given your situation with a Postgres CDC → Snowflake connection where syncs complete but 0 records are replicated, here’s how the Airbyte actions differ and what is recommended: ###
Refresh Data - A
Refresh Sync erases the current cursor for incremental streams and re-imports data from the beginning, but does
not delete existing data until the new data is ready. It is useful if you want to re-attempt syncing or recover from a bad state, but it does
not clear out the destination tables entirely. It does
not create data downtime, as the previous data remains available until the refresh completes. However, if the state is corrupted or missing (as in your case), a refresh may not resolve the underlying issue [[Refreshing your data](
https://docs.airbyte.com/platform/operator-guides/refreshes)]. ###
Clear Data -
Clear Data (previously called "Reset") erases all data that Airbyte has created in your destination for the selected streams or the entire connection. This is a destructive operation: all records are deleted from the destination tables, and you will need to run a sync to reload data. This is recommended if you want to start fresh and ensure no corrupted or partial data remains. Note: this causes data downtime, as the tables will be empty until the next sync completes [[Clearing your data](
https://docs.airbyte.com/platform/operator-guides/clear)]. ###
Delete and Recreate the Connection -
Deleting and recreating the connection is the most drastic step. This will remove all configuration, state, and history for the connection. You would need to set up everything from scratch. This is only recommended if other recovery options fail or if you suspect the connection configuration itself is corrupted. --- ###
What Should You Do? Based on the knowledge sources, if your connection is stuck in an inconsistent state (e.g., missing per-stream state, no records replicated), the recommended approach is to
Clear Data for the affected streams or the entire connection. This will remove all previously synced data and allow you to start with a clean slate. After clearing, run a new sync to backfill the data. If clearing does not resolve the issue, then consider deleting and recreating the connection as a last resort.
Summary: -
Try "Clear Data" first to reset the destination and state. -
If issues persist after clearing and resyncing, then delete and recreate the connection. > There is no way to recover from a clear sync, so please be certain that you wish to erase all the data in your destination. > In order to backfill all historical data, a sync should be initiated after your clear succeeds [[Clearing your data](
https://docs.airbyte.com/platform/operator-guides/clear)]. If you only want to re-import data without deleting it first, use "Refresh." But for state corruption, "Clear Data" is the more robust option. If you need step-by-step instructions for clearing data, let me know!