Transformations

Orchestrate custom data transformations in your destination with Fivetran.

---

Overview

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 features

The following table lists the main features of our *:

Feature	Transformations for dbt Core
SQL transformations	check
Transformation dependency	check
Version control	check
Data lineage graphs	check
Automated documentation	check
Integrated schedules	check
Pre-built data models	check

and are free in Fivetran and don't count towards your Fivetran costs. However, transformations run in your connected destination on your warehouse's compute resources. Make sure to size your warehouse properly to accommodate transformation execution.

---

* 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.