Error: Cannot Select - (CT) Missing VIEW CHANGE TRACKING Permission

Issue

While trying to include a table in the connection schema, the following error appears:

Cannot select - (CT) Missing VIEW CHANGE TRACKING permission

Environment

• Connector: SQL Server
• Incremental update method: Change tracking (CT)

Resolution

To resolve this issue, grant the Fivetran user permission to view CT metadata for each affected table using the following query:

GRANT VIEW CHANGE TRACKING ON [<schema>].[<table>] TO <username>;

Cause

This issue occurs when you enable CT on a table, but the Fivetran user lacks permission to access the table's CT metadata.