Company
Date Published
March 30, 2022
Author
Natalie Waller
Word count
846
Language
English
Hacker News points
None

Summary

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.