Aviad Deri
05/27/2024, 1:59 PMkapa.ai
05/27/2024, 1:59 PMrowversion
as a cursor incremental column in the MSSQL source connector for Airbyte. However, there are some relevant points that might be of interest: 1. Incremental Sync Issues: There have been issues related to incremental syncs with the MSSQL source connector, such as syntax errors when running certain queries on Azure Synapse Analytics ([source](https://github.com/airbytehq/airbyte/issues/30642)). 2. Nullable Columns as Cursor: For the Postgres source, there was an issue related to nullable columns being used as cursors, which was resolved ([source](https://discuss.airbyte.io/t/2694)). This might indicate that similar issues could exist or be resolved for MSSQL. 3. Change Tracking and CDC: There is a mention that the MSSQL source currently relies on Debezium for incremental syncs, which in turn relies on SQL Server's CDC (Change Data Capture). There are no current plans to implement incremental syncs using Change Tracking, but it is not ruled out ([source](https://github.com/airbytehq/airbyte/issues/27493)). Given these points, it is not clear if rowversion
is specifically supported as a cursor incremental column. For the most accurate and up-to-date information, you might want to check the official Airbyte documentation or raise a query on their [GitHub issues page](https://github.com/airbytehq/airbyte/issues) or [community forum](https://discuss.airbyte.io/). If you have any specific requirements or issues, providing more details might help in getting a more precise answer from the community or the Airbyte support team.