Edit on GitHub
How Fivetran Maintains Change Tracking Minimum Valid and Current Versionslink
Questionlink
How does Fivetran maintain the CHANGE_TRACKING_MIN_VALID_VERSION
and CHANGE_TRACKING_CURRENT_VERSION
for a change tracking-enabled table?
Environmentlink
Connector: SQL Server with change tracking enabled
Resolutionlink
We query your SQL Server database using the CHANGE_TRACKING_MIN_VALID_VERSION
function, which returns the CHANGE_TRACKING_MIN_VALID_VERSION
for the table. The CHANGE_TRACKING_CURRENT_VERSION
of the table is stored in Fivetran's production database.