Tools

Data transformation

6 tools compared: how each is priced, where it runs, and what to consider instead.

Tool Pricing model Free tier Open source
Coalesce GUI-driven Snowflake transformation tool that generates and version-controls SQL, aimed at teams who want dbt's rigor with a visual editor. Subscription Yes No
Datafold Data diffing and CI tool that catches unintended changes in dbt (and other) pipelines before they reach production. Quote only No No
Dataform Google Cloud's built-in SQL transformation tool for BigQuery, offering dbt-like modeling without a separate platform to run. Free Yes Yes
dbt Transforms data already in the warehouse with SQL SELECT statements, adding version control, testing, documentation and lineage. Open source + paid Yes Yes
SQLMesh Open-source SQL transformation framework with column-level lineage and virtual data environments, built as a drop-in dbt alternative. Open source + paid Yes Yes
Y42 Managed DataOps platform combining ingestion, dbt-core/SQL/Python transformation, orchestration, and governance in one workspace. Subscription Yes No

In the index now