Use Caselink
You want to use Transformations for dbt Core, but you are already using basic SQL transformations within your account.
Recommendationslink
- Create a new destination.
- 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.