Issue with Incremental Syncs from MSSQL sources

Summary

Users facing problems with syncs in ‘Incremental | Append’ mode from MSSQL sources where tables are randomly completely re-loaded due to cursor evaluation issues on ‘LastUpdated’ field.


Question

Hi all, I’ve been encountering an issue performing syncs in “Incremental | Append” mode from MSSQL sources, the tables get randomly completely re-loaded as if Airbyte cannot correctly evaluate the cursor on LastUpdated (with microsecond resolution but without timezone offset) Has anyone encountered this problem before?



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["incremental-sync", "mssql-sources", "cursor-evaluation", "lastupdated"]