Question
What is a cursor reset in a connector and how is data affected?
Answer
state is a JSON object containing cursors from the previous successful sync of any connector. A cursor is a timestamp, id, or index that marks what data has already been synced.
When we start the next sync, we use the cursor to decide from where to start. Think of the cursor as a bookmark in your data that lets us start reading from where we left off.
If there is a data integrity issue on a table that needs a resync (on a connector that does not support table-level resync via UI), you may need to reach out to the Fivetran Support team to do a cursor reset for the particular table.
A cursor reset depends on what we are trying to fix but in general we will carry out one of the following:
- Remove the cursor timestamp of the table so that we will do a full import.
- Change the cursor timestamp to a particular time to do a partial import on the table.