Warning: Cannot Unselect – Core Tables Cannot Be Blocked (CONTENTVERSION Table)
Issue
When you try to deselect the CONTENTVERSION table in the Schema tab, the following warning appears:
Cannot unselect – Core tables cannot be blocked.
Environment
Connector: Salesforce
Resolution
To resolve this issue, disable the Sync Salesforce Files setting:
- In Fivetran, go to your Salesforce connection page.
- Select the Settings tab.
- Click Edit connection.
- Set the Sync Salesforce Files to your destination's object storage toggle to OFF.
- Click Save & Test.
- Select the Schema tab and clear the checkbox next to
ContentVersion.
For more information, see Salesforce Files.
Cause
This issue occurs when the Sync Salesforce Files to your destination's object storage setting is enabled. When enabled, Fivetran treats CONTENTVERSION as a core table, which means it can't be deselected.