What is a cursor reset in a connector, and how does it affects data?
A cursor is a bookmark that marks the data Fivetran has already synced (for example, a timestamp, ID, or index). It is key to performing incremental updates. When we initiate the next sync, we use the cursor to decide from where to start. Think of the cursor as a metaphorical bookmark in your data that lets us start reading from where we left off.
A cursor reset changes the bookmark value that we maintain.
Our support team can perform the following two types of cursor resets:
- Remove the table’s cursor. You can perform a full table re-import.
- Change the table’s cursor to a different date or time. You can perform a partial table re-import.