Why Do I See an Increase in MAR?
Question
Why do I see an increase in monthly active rows (MAR) for my Salesforce connector?
Environment
Connector: Salesforce
Answer
Re-import tables
When non-replicateable tables are fully re-imported for the first time at the beginning of the month, this will increase the MAR count. These tables are marked Not recommended
in the connector schema. You can choose to exclude them if they are not necessary.
Bulk updates in the source
We incrementally sync data for most Salesforce tables. To track when data was last updated in the source, we use one of the following timestamp fields:
SystemModStamp
LastModifiedDate
CreatedDate
LoginTime
Salesforce updates the SystemModStamp
field for user actions and automated processes. Therefore, automated processes that impact a large number of records may result in an increase in your MAR consumption.
History mode
When you enable history mode for a table, we record every change to a record as a new row. Therefore, enabling history mode may increase your MAR consumption, particularly for large or frequently updated objects.