Destination Improvement: Fivetran sync should not sync values of a saleasforce object but must have formula definition for all objects
Possibility of offering SQL translation for formulae fields of salesforce objects and not syncing the data for the related salesforce objects.
Currently, Fivetran syncs the salesforce objects into snowflake database. It creates a FIVETRAN_FORMULA_MODEL table which has the sql to reproduce the formula fields containing joins to dependent objects. All the dependent objects are also synced and hence the sql will contain joins to the dependent tables which is in the FIVETRAN_FORMULA_MODEL.
What we are trying to achieve is: Sync just one salesforce object(Opportunity) to snowflake. We would want the FIVETRAN_FORMULA_MODEL table to have the entire SQL containing joins to dependent objects in the 'model' column but not sync any data for the other objects.
Please sign in to leave a comment.
Comments
0 comments