Transformations | Fivetran

Take control of your data pipeline

Enable data teams to work together with integrated SQL-based post-load transformations

Choose between two powerful solutions for handling in-warehouse transformations

Fivetran Transformations
Enable data teams to execute simple post-load transformations with an easy to use tool

dbt Transformations
Orchestrate sophisticated data transformations, model dependencies, and data validation with dbt

Run post-load SQL transformations in-warehouse. Focus on delivering data the business needs today

SQL-based transformations
Enable anyone who can write SQL to build data transformations
Simple UI Scheduler
Schedule transformations to run as often as every 5-minutes to 24-hours
Trigger-based transformation
Only run transformations when you need it, once new data syncs to a table

FIVETRAN + DBT

Orchestrate the testing, transformation, modeling, and documentation of data sets with Fivetran + dbt together

Link to any Git repository provider via SSH for a secure connection
Job orchestration
Enjoy a complete data pipeline solution of automated extraction, ready-to-query schemas, and SQL-based transformations
dbt packages
Quickly create reports with pre-built dbt packages designed for analytics
Trigger Transformations (Coming Soon)
Run complex transformations only once new data syncs to a table

Let Fivetran connect directly to your git repository

Receive automated alerts when a job or test fails

Install Fivetran dbt packages and model your own data with SQL

Trust the data in your models and automate the tests against your transformations

Orchestrate dbt jobs with Fivetran and deploy directly to production

Leverage dbt package documentation and create your own as you build your models