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 metaphorical 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 but it is one of the few connectors we offer that do not support table-level re-sync via UI then you will need Fivetran support to do a cursor reset for the particular table.
A cursor reset depends on what we are trying to fix but in general we either:
- 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
Comments
0 comments
Please sign in to leave a comment.