Automatically sync formula field values to Salesforce

Fivetran has introduced a solution for syncing Salesforce formula field values to data warehouses without manual translation from SOQL to Standard SQL. The feature includes the Fivetran_formula table and the Salesforce Formula Utils transformations package, which automatically maintain custom formulas and generate accurate representations of formula field values as views in the warehouse. This enables data analysts to access reliable and up-to-date Formula Field data for analysis alongside other sources. To get started, users need to sync their Salesforce data with Fivetran and use dbt Core for data modeling.