# Have you struggled recreating salesforce formula from fivetran in Snowflake ?

**URL:** <https://discourse.getdbt.com/t/have-you-struggled-recreating-salesforce-formula-from-fivetran-in-snowflake/20581>\
**Category:** Show and Tell\
**Tags:** best-practice, packages, snowflake, macros, dbt-core\
**Created:** [February 13, 2026, 3:32pm UTC](https://discourse.getdbt.com/t/have-you-struggled-recreating-salesforce-formula-from-fivetran-in-snowflake/20581 "2026-02-13T15:32:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![munmridul](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/munmridul/32/5925_2.png) [@munmridul](https://discourse.getdbt.com/u/munmridul)\
**Post date:** [February 13, 2026, 3:32pm UTC](https://discourse.getdbt.com/t/have-you-struggled-recreating-salesforce-formula-from-fivetran-in-snowflake/20581/1 "2026-02-13T15:32:18Z")

</div>

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:**

> **[GitHub - Mridul98/dbt\_salesforce\_formula\_toolkit: An open source dbt package offering basic toolkit...](https://github.com/Mridul98/dbt_salesforce_formula_toolkit)**
>
> An open source dbt package offering basic toolkit to create salesforce objects with formula and rollup summary fields in SQL model, materialized as table / view

**Example Usage:**

Install by adding the package in package.yml file:

```auto
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.

```auto
{{
    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!