How Can I Get the SQL Translation of a Salesforce Formula Field?

Question

How can I get the SQL translation of a Salesforce formula field?

Environment

Connector: Salesforce Transformations

Answer

To get the SQL translation of a Salesforce formula field, do the following:

1. Query the FIVETRAN_FORMULA_MODEL table, filtering by your formula field's Salesforce object name. Use the following query:

   SELECT model
   FROM <destination name>.fivetran_formula_model
   WHERE object = '<salesforce object name>'
   

2. Search the formula model returned in step 1 for your formula field's alias using the format AS <formula field>.

IMPORTANT: If your formula field alias translates as null, it may be due to a known failure reason. See our translation failure reasons documentation for more information.