How Does Fivetran Maintain Change Tracking Minimum Valid and Current Versions?

Question

How does Fivetran maintain the CHANGE_TRACKING_MIN_VALID_VERSION and CHANGE_TRACKING_CURRENT_VERSION for a change tracking-enabled table?

Environment

Connector: SQL Server with change tracking enabled

Resolution

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.