Tables or Fields Are Missing From the Destination

Issue

Tables or fields in Salesforce are missing from my destination. In some cases, the following alert appears on the Fivetran dashboard:

Table Excluded By System

Environment

• Connector: Salesforce
• Connector: Salesforce Sandbox

Resolution

To learn how to resolve this issue, see the scenarios below.

Fivetran is unable to access the table or field

We won't sync a table or field if the authorizing user doesn't have the permission required to access it. To sync all applicable data, ensure the authorizing user has permission to read the data from Salesforce's API. See Salesforce's Configure Permissions and Access documentation for more information.

Fivetran doesn't support the data type or object type

We don't support some Salesforce data types and object types. See our Salesforce unsupported data types documentation for more information. To sync unsupported data types, we recommend utilizing one of the workarounds described in our Syncing Data From Non-Native Sources documentation.

The field is a formula or lookup field

Due to Salesforce limitations, we don't sync formula fields to the tables in your destination. See our Salesforce sync overview for more information. We recommend using either of the transformation-based approaches mentioned in our Salesforce Formula Fields documentation to sync formula fields.