How to Migrate Basic SQL Transformations to dbt Transformations

Use Caselink

You want to use Transformations for dbt Core, but you are already using basic SQL transformations within your account.

Recommendationslink

1. Create a new destination.
2. Configure dbt Core within this destination.

Causelink

Fivetran does not allow a single destination to be configured with both basic SQL transformations and Transformations for dbt Core.

Follow Fivetran’s recommendations to run both Transformations for dbt Core and basic SQL transformations in parallel and test out your transition to transformations with dbt Core.

Considerationslink

You can also use a different Fivetran user to run Transformations for dbt Core on additional destinations.