Why Are Some Salesforce Tables Empty in My Destination?
You may encounter empty tables in your destination, even though the corresponding data exists in Salesforce and the table is included in your connection schema. Find out why your tables are empty and how to adjust user permissions to ensure the data is accessible.
What causes empty Salesforce tables in the destination?
You may encounter empty tables in your destination when Salesforce sharing settings prevent the connection's authenticating user from viewing records in the object associated with the empty table.
How to ensure the data is accessible
To resolve this issue, grant the authenticating user the View All permission on the relevant objects. This permission bypasses sharing settings and ensures the user can access all records in the objects.
You must have administrative privileges to set permissions in Salesforce.
Cause
This issue occurs when Salesforce sharing settings prevent the user authenticated with the Fivetran connection from viewing records in the associated object. Providing View All permissions bypasses restrictions caused by sharing settings.