# Matillion

> Visual ELT that pushes transformations into the warehouse

Matillion is a commercial data integration platform with a visual pipeline builder, loading data into cloud warehouses and pushing transformation work down to the warehouse's own compute rather than processing it separately.

Website: https://www.matillion.com

## Use it when

- Pipelines should be built visually by a mixed-skill team rather than maintained as code.
- The destination is Snowflake, Databricks, Redshift, or BigQuery, and transformations should compile to SQL pushed down to it.
- An enterprise procurement wants one vendor covering load, transform, and orchestration.
- Sources include databases needing CDC, run through an agent in your own cloud.

## Think twice when

- Warehouse compute is the hidden line item: every transformation executes on the warehouse, billed by the cloud provider on top of Matillion's credits, and can be the larger of the two bills.
- The destination is not one of those four cloud warehouses; nothing else is a target.
- You want self-serve, code-first workflows; dbt with Airbyte or dlt fits that shape better.
- Budget favors flat or open-source pricing over credit consumption.

## How it runs

A managed SaaS with hybrid agents for CDC and private data: orchestration and transformation pipelines are drawn on a canvas and compiled to warehouse SQL, so the warehouse computes and Matillion coordinates. Schedules run in the platform, and credits meter task hours and additional developers.

## Details

### General

| Attribute | Value |
| --- | --- |
| License | Commercial |
| Deployment | Managed, Self-hosted, Hybrid |
| Workload | Batch |
| Operational complexity | Medium |
| Pricing | Subscription |
| Documentation | https://docs.matillion.com |

### Batch ELT

| Attribute | Value |
| --- | --- |
| Authoring model | Visual canvas; transformations compiled to warehouse SQL |
| Source coverage | SaaS APIs, databases and files, plus any JSON REST API |
| Destinations | Cloud warehouses only: Snowflake, Databricks, Redshift, BigQuery |
| Custom connectors | Custom Connector: any JSON REST API, configured in the UI |
| Incremental sync | Batch incremental loads; CDC pipelines via an agent in your cloud |
| Sync frequency | Scheduled pipelines; CDC writes change files in near real time |
| Schema drift | Configurable on CDC; driven by data changes, not source DDL |
| Transformations | Visual canvas compiled to warehouse SQL, the warehouse computes |
| Scheduling | Built in: orchestration pipelines and schedules in the platform |
| Billing unit | Credits, consumed by task hours and extra developer users |

## Capabilities

- [Batch ELT](https://matca.io/capabilities/batch-elt)

---

Source: https://matca.io/matillion
Last updated: 2026-08-31T11:40:47.352Z