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

SQL Server connectors

Resolution

To resolve this issue, grant the Fivetran user permission to view change tracking (CT) metadata on the applicable table using the following query:

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

Cause

This issue occurs when change tracking is enabled on a table, but the Fivetran user lacks permission to access the table's change tracking metadata.