Updated September 19, 2023
Orchestrate pre-built and custom data transformations in your destination with Fivetran.
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.
|Feature||Transformations for dbt Core||Quickstart data models|
|Data lineage graphs||check||check|
|Pre-built data models||check||check|
|Customizable data models||check|
NOTE: Transformations for dbt Core and Quickstart Data Models can be used simultaneously 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.
TIP: Quickstart data models are Fivetran's no-code solution for transformations downstream of Fivetran connectors. Setup only takes a few minutes, and we recommend starting here before exploring Transformations for dbt Core.
* 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.