Connector Improvement: Salesforce Connector - Introduce Updated timestamp on table fivetran_formula
Not plannedHi Fivetran team,
We are using Salesforce connector to sync Salesforce data into Snowflake. The current Salesforce connector includes a feature to sync the Salesforce formula fields definition in the destination schema, with table name - fivetran_formula. This is a good feature and helpful for us to get the Salesforce source formula logic. Along with the Salesforce Quickstart Transformation package, we are able to bring Salesforce formula definition to Snowflake smoothly.
However, I have a requirement to get alert when a Salesforce formula field logic is updated. Currently in this table fivetran_formula, there is a timestamp column _fivetran_synced. This timestamp is ovewritten every fivetran load. Even there is no change on the formula definition, the _fivetran_synced timestamp will be updated to the recent reload time. I am expecting a updated timestamp to show the latest updated time when the formula logic is updated. With this column, I can trigger a lot of downstream actions, for example send alert to our data engineering teams that source application Salesforce updated some formula field logic.
That will be helpful if you can consider this and build this additional updated timestamp in this fivetran_formula table.
Thanks!
Matthew
-
Official comment
Hi Matthew,
Salesforce doesn't provide a way for us to detect when a formula field definition changes, which is why we have to re-import this table on every sync (and why you see the timestamp being updated on every sync). I recommend you reach out to Salesforce Support and request this feature - it's definitely something that would help a lot of customers!
Best,
Sadie
Please sign in to leave a comment.
Comments
1 comment