Home Transform and orchestrate Transformation

Transformation

SQL modeling frameworks that turn raw tables into tested, documented models.

Showing 12 tools
Loading tools…

Y42

Visual/managed

Git-native platform running ingestion, dbt Core models, orchestration and virtual data builds on BigQuery or Snowflake, from $500 a month.

Visit site

Prophecy

Visual/managed

AI data prep platform: agents draft visual pipelines that compile to dbt-backed SQL or PySpark in Git, on DuckDB, Databricks, Snowflake or BigQuery.

Visit site

Alteryx

Data prep

No-code data prep and analytics platform (Alteryx One) with Designer desktop, Designer Cloud, Server and AI agents, sold per seat plus automation runs.

Visit site

KNIME

Data prep

Free, open-source visual data-prep and analytics desktop with Python, R and LLM nodes; paid Hub plans add scheduling, data apps and team spaces.

Visit site

Dataform

SQL framework

Google Cloud's free SQL transformation framework inside BigQuery: SQLX models, assertions, incremental tables, unit tests and built-in scheduling.

Visit site

Coalesce

Modern catalog

Column-aware visual transformation for Snowflake, Databricks, BigQuery and Fabric, with Catalog and Quality bundled; free Developer plan, Starter $150 per user per month.

Visit site

Matillion

Enterprise ETL

Visual ELT, transformation and orchestration platform (Maia Foundation) that pushes work down into Snowflake, Databricks, Redshift or BigQuery, billed in credits.

Visit site

Rivery

Managed ELT

Managed ELT platform (now Boomi Data Integration) with SQL and Python Logic Flows, orchestration and CDC, billed in BDU credits.

Visit site
Custom pricing

Tobiko Cloud

SQL framework

Managed SQLMesh platform for data transformation, with deployment planning, model scheduling, debugging, and warehouse cost estimates.

Visit site
Open source / paid hosting

SQLMesh

SQL framework

Open-source SQL and Python transformation framework with deployment plans, reusable development environments, unit tests, and data audits.

Visit site
Free plan; paid seats plus usage

dbt Cloud (dbt Labs)

SQL framework

Managed dbt development and deployment with Studio, job scheduling, CI, project-aware AI assistance, and governed metrics for analytics teams.

Visit site
Free tier

dbt

SQL framework

Panoply Score: 83/100

The standard for SQL transformation. dbt Core is open source; dbt Cloud adds a scheduler and IDE, free for one seat and $100 per seat a month on Starter.

Visit site