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 at both the table and database levels using the following queries:

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

GRANT VIEW CHANGE TRACKING 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.