How Do I Configure My Salesforce Schema to Support Formula Fields and Models?

Once you have enabled Fivetran's formula fields transformation solution, you must include the corresponding tables in your connection schema. To ensure your formula fields translate without issue, you must also include all formula dependencies in your connection schema.

To adjust your connection schema configuration, do the following:

1. In Fivetran, go to your Salesforce connection 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.