Dataform is Google Cloud's free SQL transformation tool for BigQuery. Learn its key features, dbt comparison, pricing model, and how data teams use it daily.
Free (usage billed via underlying BigQuery and Google Cloud services), from Free
Verified
Not yet
Last updated
July 18, 2026
Founded
2017
Headquarters
Mountain View, California, USA (Google Cloud)
Free PlanWeb AppAPI
Overview
Dataform is a Google Cloud service for developing, testing, and orchestrating SQL-based data transformation pipelines natively inside BigQuery. It originated as an independent London startup founded in 2017 by Lewis Hemens and Guillaume-Henri Huon, before Google Cloud acquired it in December 2020.
Since the acquisition, Dataform has been rebuilt as a BigQuery-native product, dropping its earlier multi-warehouse support in favor of tight integration with Google's own data platform.
Key Features
Dataform lets analytics engineers define SQL transformations with automatic dependency resolution, real-time error checking, and a visual dependency graph, plus data quality assertions for testing.
Native Git integration connects Dataform repositories to GitHub or GitLab for version control and code review, while workflows can be scheduled via Cloud Scheduler, Cloud Workflows, or Managed Apache Airflow.
Pricing
Dataform itself is a free Google Cloud service with no direct licensing fee. Costs instead come from the underlying BigQuery queries Dataform runs, plus Cloud Logging and any orchestration services used (Cloud Scheduler, Workflows, or Managed Airflow).
This makes Dataform effectively free to adopt for teams already using BigQuery, since there is no separate transformation-tool subscription on top of existing Google Cloud spend.
Key Features
SQL-Based Transformations — Define tables, views, and incremental models using SQL with JavaScript-based templating and configuration.
Automatic Dependency Resolution — Executes transformation pipelines in the correct order based on references between models, with dependency graph visualization.
Native Git Version Control — Connects to GitHub or GitLab for commits, pull requests, and code review directly from the Google Cloud console.
Data Quality Assertions — Built-in tests to validate data properties such as uniqueness and non-null constraints as part of a pipeline.
Flexible Scheduling — Trigger workflows manually or schedule them via Cloud Scheduler, Cloud Workflows, or Managed Service for Apache Airflow.
Real-Time Error Checking — Immediate feedback on SQL and dependency errors while building transformations in the editor.
Native BigQuery Integration — Runs transformations directly inside BigQuery without needing a separate compute layer.
Pros & Cons
Pros
No direct licensing cost; Dataform itself is free to use
Deep, native integration with BigQuery simplifies setup for Google Cloud users
Flexible orchestration options via Cloud Scheduler, Workflows, or Managed Airflow
Cons
Locked into BigQuery; no longer supports Snowflake or Redshift as it did pre-acquisition
Real costs come from BigQuery query execution, Cloud Logging, and orchestration services, which can add up
Smaller community and ecosystem compared to dbt
Less flexible for multi-warehouse or multi-cloud data stacks
Pricing
Dataform (Free Service) Free N/A
Frequently Asked Questions
Is Dataform free?
Dataform itself has no direct licensing fee, but running its SQL transformations incurs standard BigQuery query costs, plus Cloud Logging and any orchestration service charges.
What is Dataform used for?
Dataform is used to develop, test, version-control, and schedule SQL-based data transformation pipelines that run inside BigQuery.
How is Dataform different from dbt?
Dataform is a free Google Cloud service tightly integrated with BigQuery only, while dbt is an independent, multi-warehouse transformation framework supporting Snowflake, Redshift, Databricks, and more.
Who created Dataform?
Dataform was founded in 2017 by Lewis Hemens and Guillaume-Henri Huon in London and acquired by Google Cloud in December 2020.
Does Dataform support version control?
Yes, Dataform integrates natively with Git and supports connecting repositories to GitHub or GitLab for commits and code review.
Can Dataform be used with data warehouses other than BigQuery?
No, since being rebuilt as a Google Cloud product, Dataform is designed to run natively and exclusively inside BigQuery.