How Must I Configure My Schema to Ensure Formula Models and Fields Populate?

Question

I have enabled Fivetran's formula fields transformation solution. How must I configure my connector's schema to ensure formula models populate and formula fields translate without issue?

Environment

• Connector: Salesforce Transformations
• Fivetran's formula field transformation solution

Answer

To ensure formula models populate in your destination, you must select the corresponding tables in your connector's schema. To ensure your formula fields translate without issue, you must also select all formula dependencies in your connector's schema.

To review your connector's schema configuration, do the following:

1. In Fivetran, go to your Salesforce connector page.
2. Select the Setup tab.
3. Ensure you have selected the checkbox next to all applicable tables and fields.
4. If you have made any changes, click Save changes.

If you encounter translation failures or null values, see Why Do Some Formula Fields Translate to null Values? to learn more or contact our support team.