Warning: Cannot Select - Duplicates History Data

When you try to select a table, such as the Opportunity_hd table, in the Schema tab, you may encounter the following warning:

Cannot Select - Duplicates history data.

Why the Duplicates history data warning appears

We don't support syncing historical data objects from Salesforce, such as Opportunity__hd, because they duplicate data we already provide through our history mode sync mode. History mode lets you track changes to Salesforce objects without syncing history tables.

How to track history using history mode

To enable history mode for an object such as Opportunity, do the following:

1. In Fivetran, go to your Salesforce connection page.
2. Select the Schema tab.
3. Locate the object you want to track.
4. In the Sync mode column, click the current mode name to open a drop-down menu.
5. Select History mode.
6. Click Save changes.

To learn more, see our documentation on changing sync modes.