Issue with MSSQL Source Connector in Airbyte

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.

Join the conversation on Slack

["mssql-source-connector", "full-sync", "overwrite", "user-defined-cursor", "indexing", "custom-db"]