Manage data in your warehouse

Dataform helps analysts manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes.

CREATE TABLE ...
success
INSERT INTO ...
error
ASSERT THAT ...
passed
GRANT SELECT ON ...
success
image of product showing the web IDE

Prepare your data for analysis

With Dataform, build and schedule SQL workflows that transform raw data into reliable datasets ready for analysis, directly from your cloud data warehouse.

How Dataform works

1. Develop

Develop your transformations in SQL

Develop SQL from a rich cloud IDE. As you write SQL, use the Dataform SDK to seamlessly create tables, define dependencies and more.

Work as a team

Dataform lets your team members develop simultaneously in the cloud, from different branches.

2. Schedule

Scheduling made easy

Simply say how often you want your datasets to update and Dataform will do the rest. Dataform builds a dependency tree (DAG) of all your datasets and makes sure your datasets are updated in the right order.

Notifications and logging

Dataform alerts you when potential errors error occurs and gives you detailed logs so you can fix issues quickly.

3. Use your data

Reliable and up to date data for your analytics

Use reliable and up to date datasets for all your analytical purposes: reporting, BI tools or advanced analytics.

Create a single source of truth for your data definitions

All your data definitions are stored in a single repository, synced with GitHub and accessible by your entire team.

4. Seamlessly adopt software engineering best practices

Version control

Dataform development environment integrates with Git where users can work from individual branches. Push your changes directly or enforce code reviews for all changes.

Automate data quality testing

You can’t make informed decisions if you don’t trust your underlying data. Dataform lets you define tests against your input raw data and the output of data transformations, with issues triggering alerts before they hit your analytics.

Safe deployments

With Dataform, your team can deploy on isolated schema while developing and use CI/CD to integrate new changes safely.

Built for developers too

Dataform is fully code configurable. Write re-usable code snippets, automate actions through our API, or self-manage through our open source CLI.

Check out the developers page for examples, or read the docs.

Build a data warehouse you can be proud of

With Dataform, you can publish your first dataset in just 5 minutes

Already using Dataform? Log in