We want to have row tracking on delta tables in MDLS. We need it for better incremental processing in our pipelines.

Row tracking was introduced in Delta Lake 3.2.0, with Delta protocol requirements:

• minWriterVersion=7
• minReaderVersion=1

Current version of Delta protocol in MDLS destination:

• minWriterVersion=2
• minReaderVersion=1

As mentioned in this Fivetran support article:

We use the Delta Standalone Java library to create and manage tables. This library supports writing and reading Delta Lake tables with protocol version (writer: 2, reader: 1).

To support more recent versions of Delta lake protocol and its features, the Fivetran backend would have to switch from Delta Standalone library (which is now officially deprecated) to Delta Kernel APIs.