Currently, we are seeing historical data re-sync through the Salesforce connector, whenever a rollup summary column is added to a salesforce object. This will update the 'SystemModStamp' throughout the table to the latest and Fivetran does a resync of the whole table.
Per Fivetran article :
In Salesforce, we use one of the following timestamp fields to track when data was last updated in the source:
There is a business impact since the data resync will run more than 2 days with no latest refreshed data in SNOWFLAKE.
Since we do not have control over the above columns, is there a way to add/implement a feature to select a particular timestamp field in the Salesforce Connector? so that we can set the required columns ( Ex: LastModifieddate in our use case), based on the requirement?
I appreciate it if you can prioritize this task and provide an update as early as possible.