Have you struggled recreating salesforce formula from fivetran in Snowflake ?

Show and Tell
, , , ,
1

Introducing the new package that you can use to materialize formula and rollup summary fields from Salesforce using Fivetran. Although Fivetran offers their own dbt package for it, my solution is pretty much simpler and intuitive to understand.

Give it a try if you want to:

Example Usage:

Install by adding the package in package.yml file:

packages:
  - git: "https://github.com/your-org/dbt_salesforce_formula_toolkit.git"
    revision: main

This example demonstrates the use of macro provided my the package to materialize salesforce account object as view along with all the formula and rollup summary.

{{
    config(
        materialized='view',
    )
}}
{{ dbt_salesforce_formula_toolkit.get_salesforce_object_model_sql(
    '<source_database>', '<source_schema>', 
    'account'
    ) 
}}

Also, I will appreciate open source contribution from you guys.

Thanks!