ELT & data integration · Matillion

Matillion

Cloud-native ELT platform with a low-code visual pipeline designer that pushes transformations down into the target warehouse.

Visit Matillion Alternatives

Matillion's Data Productivity Cloud is a browser-based, low-code environment for building ELT and reverse ETL pipelines with a drag-and-drop canvas, alongside SQL and Python scripting components for more complex logic. Rather than transforming data in its own engine, Matillion pushes transformation SQL down to run inside the destination warehouse (Snowflake, Databricks, BigQuery or Redshift), which keeps compute costs and data movement inside the customer's existing platform. Pipelines are version-controlled through a built-in Git repository, and higher tiers add streaming change data capture, custom SSO, hybrid deployment and longer log retention. It targets analytics engineering teams who want more visual control and native dbt Core integration than a purely managed connector service like Fivetran provides.

At a glance

Vendor Matillion
Pricing model Quote only
Free tier No
Deployment Cloud
Open source No
Best for Analytics engineering teams wanting a visual, low-code ELT builder with warehouse-native transformation.

Pricing

Consumption-based credit system tied to pipeline task hours and developer seats; only the entry Developer tier's trial is self-serve, the rest require a sales quote.

Plan Price Notes
Developer Free trial 1 developer user, unlimited admin users, unlimited projects
Teams Contact sales 5 developer users, audit log, standard support and SLA; marked most popular
Scale Contact sales Adds custom SSO, hybrid cloud deployment, data lineage, streaming CDC, 180+ day log retention

Prices read from the vendor's own page on September 21, 2026. Vendors change prices; check the source before you budget.

Features

  • Low-code drag-and-drop pipeline canvas
  • Push-down transformation execution in the warehouse
  • Built-in Git version control
  • SQL and Python scripting components
  • Native dbt Core integration
  • Streaming change data capture (Scale tier)
  • Cross-cloud support for Snowflake, Databricks, BigQuery, Redshift

Integrations

Profile last reviewed September 21, 2026

Head to head

Alternatives

Fivetran Managed ELT platform with 700+ prebuilt connectors that automatically syncs source data into a cloud warehouse or lake. Talend Enterprise data integration and data quality suite, now sold as Qlik Talend Cloud after Qlik's acquisition of Talend. Azure Data Factory Microsoft's cloud ETL/ELT and orchestration service for building and scheduling data pipelines across Azure and hybrid sources. AWS Glue Serverless AWS ETL service using Apache Spark under the hood, billed per Data Processing Unit-hour with no infrastructure to manage.

Matillion in the index now

Terms to know

ELT (extract, load, transform) A data integration pattern that loads raw data first and transforms it afterward using the warehouse's own compute. ETL (extract, transform, load) A data integration pattern that transforms data before loading it, unlike ELT which transforms after loading. Data pipeline The automated sequence of steps that moves data from source systems to a destination, transforming it along the way. Data warehouse A centralized, structured database optimized for fast historical reporting rather than day-to-day transactions. Analytics engineer A role that builds and maintains the transformed, tested data models analysts and dashboards rely on. Change data capture (CDC) A technique for detecting and streaming only the rows that changed in a source system, instead of reloading everything.

Related guides

How to choose an ELT tool ELT tools differ less on connector count than on who operates them, how pricing scales, and whether transformation happens in the tool or downstream.