## Use Case/Scenario:

You need to implement transformation logic on your data to ensure it is fit for purpose for analysis. You need to decide if you should set-up Fivetran Transformations or dbt Transformations.

## Fivetran Recommendation:

**When to use Fivetran Transformations:**

Use Fivetran Transformations in the following circumstances;

- Your transformations are simple, quick and easy to implement.
- Your transformations have a reasonable amount of SQL Code (~50 lines).
- You do not need to build out a broad program of transformations.

**When to use dbt Transformations:**

Use dbt Transformations in the following circumstances;

- You require a scalable, robust and modular approach to your transformations.
- You require full version control, alerting and logging for your transformations.
- You have complex workflows in place that involve transformations.
- You require Documentation and diagrams such as Data Lineage Graphs to track your transformations.

## Comments

0 comments

Please sign in to leave a comment.