Orchestrate custom data transformations in your destination with Fivetran.
Overviewlink
Transformations are SQL scripts that are executed on your data based on specific events or conditions. They map your data into a shape that is easier or faster to use in the next part of your data pipeline.
Fivetran Transformations allow data teams to organize, analyze, and visualize data without sacrificing data quality or analytical flexibility. Our transformations run in your destination after we load your data in, so your raw data is always available alongside your transformed data. If a transformation fails, you do not lose data. If your analytical needs change, you can edit your transformations and run them again on your raw data.
Transformation optionslink
Fivetran offers two types of transformations:
There are several key differences between basic SQL transformations and Transformations for dbt Core:
| Feature | Basic SQL | Transformations for dbt Core |
|---|---|---|
| SQL transformations | check | check |
| Transformation dependency | check | |
| Version control | check | |
| Data lineage graphs | check | |
| Automated documentation | check | |
| Integrated schedules | check | check |
| Pre-built data models | check |
We recommend that all users who have advanced data modeling needs, such as dependencies between transformations, use Transformations for dbt Core. Basic SQL transformations are ideal for users who are new to writing SQL scripts or only need to execute simple transformations.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.