Skip to main content
Resetting sync state clears the stored cursor and CDC position. The next pipeline run will start from the beginning (full sync behaviour for incremental; from current log position for CDC).

​
When to Reset

  • Schema change — You changed the cursor column or table structure.
  • Data correction — You fixed data in the source and need to re-sync.
  • Destination reset — You truncated or dropped the destination table and want to repopulate.
  • Troubleshooting — A run failed repeatedly and you want to start fresh.

​
How to Reset

  1. Open the pipeline.
  2. Go to the sync state or settings section.
  3. Click Reset sync state (or equivalent).
  4. Confirm. The state is cleared immediately.
  5. Run the pipeline. It will perform a full sync (or CDC from the current position).
Destination dataResetting does not delete data in the destination. For replace mode, the next run overwrites. For append, you may get duplicates. For upsert, existing rows will be updated. Plan accordingly.