Fivetran Transformations

Overview Fivetran Transformations addresses the step after data lands in the warehouse: turning raw, replicated tables into clean, modeled datasets analysts can actually query. Rather than requiring a separately orchestrated tool, Transformations runs SQL-based models on a reliable schedule directly inside the customer's destination, removing the need for manual orchestration of a separate transformation layer. It integrates with dbt Core, though Fivetran is explicit that Transformations is its own product and not an endorsed dbt Labs offering. Highlights Runs SQL-based transformation models on a defined schedule immediately after source data syncs, rather than requiring a separate cron job or orchestrator; billed independently from data movement on its own consumption meter, measured in monthly model runs (5,000 free on the Free plan); integrates with dbt Core for teams that already maintain dbt-based transformation logic; designed to eliminate the common gap between "data has landed" and "data is actually usable," which otherwise requires separate transformation tooling and engineering maintenance. Supported Cloud Infrastructure Executes transformations directly within the customer's destination warehouse (Amazon Redshift, Snowflake, or Databricks, all AWS-hosted); no separate compute infrastructure required beyond the destination itself.