Why Do History Tables Use Large Amounts of MAR?

Question

Why are the Monthly Active Rows (MAR) for Salesforce mostly used by the history tables?

Environment

Connector: Salesforce

Answer

Use Fivetran's History Mode instead of Salesforce's history tables. Enable History Mode for the table and disable the history table on the Schema tab of your connector.

Disable Salesforce's history tables. Determine if you need history tables for your downstream reporting. If not, disable the tables on the Schema tab of your connector.

Cause

History tables have many active rows due to the combination of how the history tables are structured and how we define an active row.

The purpose of the history tables is to capture every single change made to a particular record. When we sync that data, every change has a unique ID associated with it. We calculate an active row based on the primary key of any given table, and the ID column of the history table is the primary key.

With history tables, each change is a new row with a new unique ID. There's never an ID that gets updated which does not count as an additional active row.