Connector Improvement: salesforce formula column modification date
Completedwe are using the FIVETRAN_FORMULA table for our salesforce connector, and it populates the _fivetran_synced column with the date of the sync for all existing formula columns, which syncs on every scheduled run.
I would like to see the actual field modification date, so we can see what salesforce formulas have recently been changed on every table. That would enable us to review the formula translation and make sure the sql is working well in our environment.
-
Official comment
Hi Johanna Buck!
Are you able to query the FIVETRAN_FORMULA_HISTORY table? This should have the information you're looking for!
Please sign in to leave a comment.
Comments
1 comment