Choosing between Fivetran native Transformation and dbt Transformations

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.