Data transformation · Google LLC (Google Cloud)

Dataform

Google Cloud's built-in SQL transformation tool for BigQuery, offering dbt-like modeling without a separate platform to run.

Visit Dataform Alternatives

Dataform is Google Cloud's native SQL transformation workflow tool for BigQuery. Analysts write SELECT statements in SQLX (SQL plus lightweight templating), and Dataform compiles them into a dependency graph, materializing tables and views, running tests, and generating documentation and lineage — the same job dbt does, but built into the BigQuery console rather than run as a separate tool. It has no compute of its own: every transformation executes as a BigQuery job, so it inherits BigQuery's pricing, permissions, and slot reservations. Dataform supports Git-backed development, workspaces for isolated development branches, and scheduled or triggered workflow execution via Cloud Workflows or Cloud Composer. It suits teams already committed to BigQuery who want dbt-style transformation without adopting a separate vendor or hosting a service themselves.

At a glance

Vendor Google LLC (Google Cloud)
Pricing model Free
Free tier Yes
Deployment Cloud
Open source Yes (Apache-2.0)
Best for BigQuery-centric teams who want dbt-style transformation without operating a separate tool.

Pricing

Dataform itself carries no license or seat fee; you pay only for the BigQuery compute (and optional Cloud Logging) your workflows consume.

Plan Price Notes
Dataform Free No direct charge; costs come from the BigQuery jobs Dataform triggers and from Cloud Logging for workflow monitoring.

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

Features

  • SQLX modeling language with templating and dependency management
  • Native integration inside the BigQuery console and API
  • Git-backed version control and development workspaces
  • Built-in data quality tests (assertions)
  • Automated documentation and column-level lineage
  • Scheduled and event-triggered workflow execution
  • Multiple environments (dev/staging/prod) via workspace compilation overrides

Integrations

Profile last reviewed September 21, 2026

Head to head

Alternatives

dbt Transforms data already in the warehouse with SQL SELECT statements, adding version control, testing, documentation and lineage. SQLMesh Open-source SQL transformation framework with column-level lineage and virtual data environments, built as a drop-in dbt alternative. Coalesce GUI-driven Snowflake transformation tool that generates and version-controls SQL, aimed at teams who want dbt's rigor with a visual editor.

Dataform in the index now

Terms to know

Data modeling The practice of organizing data into entities, relationships and schemas that make it accurate and efficient to query. Data lineage A traceable record of where data came from, how it was transformed, and where it is used downstream. dbt (data build tool) An open-source tool from dbt Labs that lets analytics teams write data transformations as version-controlled, tested SQL. ELT (extract, load, transform) A data integration pattern that loads raw data first and transforms it afterward using the warehouse's own compute. Data warehouse A centralized, structured database optimized for fast historical reporting rather than day-to-day transactions. Data quality The degree to which data is accurate, complete, consistent and fit for the purpose it is being used for.

Related guides

How to choose a data transformation tool Choosing between dbt and its rivals comes down to editor vs code, warehouse lock-in, rebuild cost and who is checking the SQL before it ships.