What Is a Cursor Reset?

Question

What is a cursor reset in a connector, and how does it affects data?

Answer

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.

Context

If you observe data integrity issues in a destination table but your connector doesn't support Table Re-sync, contact our support team to reset the cursor for the table.

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.