@kapa.ai can i use "Timestamp" or "Rowversion" column in my MSSQL source as cursor column?

The knowledge sources do not contain specific documentation about MSSQL source connector cursor field support for

Timestamp

or

Rowversion

column types. What the knowledge sources do confirm is: • Airbyte incremental sync requires a cursor field that has a well-defined ordering and no null values. [Incremental Append + Deduped] • Some connectors have limitations around certain column types as cursors. For example,

TIMESTAMP_WITH_TIMEZONE

has been reported as unsupported in some source connectors, resulting in an

Unsupported cursor type

error. [forum post] • There is also a known consideration with date-only cursors (without time granularity) in MSSQL, where records inserted between syncs on the same day may be missed due to the

>

operator used in the query. [forum post] Regarding

Rowversion

specifically, the knowledge sources do not mention it at all, so I cannot confirm whether it is supported as a cursor in the MSSQL source connector. My recommendation: Check the Airbyte MSSQL source connector documentation directly for the list of supported cursor field types, or test it in your environment. If you encounter an

Unsupported cursor type

error, you may need to select a different column (e.g., a standard

DATETIME

or integer column) as your cursor. 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.