Summary
The user is facing an issue with the MSSQL Source connector in Airbyte where only new rows are being brought in due to indexing on the ID column. They want to retrieve all data every time.
Question
Hello Team, We have been migrating our stuff from Fivetran to Airbyte and things are looking good. We noticed an issue with the MSSQL Source connector. I have the update method set to user-defined cursor (But I did not specificy any cursor). My stream is set to Full Sync a| Overwrite. However we noticed the out the box is indexing on ID column we have in source table and only brining in new rows. Am I missing a trick here? What can I do to get all the data every time. The source is not that big and it’s a custom db for a app
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.