Transformationslink
Updated September 19, 2023
Orchestrate pre-built and 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 featureslink
The following table compares the main features of our Transformations for dbt Core and Quickstart Data Models:
Feature | Transformations for dbt Core | Quickstart data models |
---|---|---|
SQL transformations | check | check |
Transformation dependency | check | check |
Version control | check | check |
Data lineage graphs | check | check |
Automated documentation | check | check |
Integrated schedules | check | check |
Pre-built data models | check | check |
Schema selection | check | |
Customizable data models | check | |
No-code setup | 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.