Product | Dataform

Where data teams work together

Dataform Web enables your entire data team to collaboratively develop, test, deploy and share a centralized data model across your organization. Powered by open source, and designed for advanced teams looking for a scalable development processes.

Dataform Web features

</>

Fully featured SQL editor

Auto save, web based and collaborative IDE for SQL and Dataform projects.

</>

Real time compilation and query validation

Dataform compiles SQLX on the fly and validates your queries for instant feedback on your code.

</>

Develop and test changes in isolation

Work in an isolated development environment, run queries, tests and inspect results before committing, without overriding production data.

</>

Deep git integration

Create individual branches for your work and keep them up to date as new changes come in.

</>

Version control made easy

Inspect changes before committing, add messages and revert files without touching a command line.

</>

Adopt modern code review processes

When your changes are tested and ready to go, create a pull request so your team can review it.

</>

Scheduling and environments

Configure schedules across multiple environments such as staging and production.

</>

Detailed execution logs

See exactly what SQL was executed when and by who, and quickly debug failing queries and tests.

</>

Get alerts via Email and Slack

Quickly react if your pipeline or data quality tests fail through email and slack notifications.

Make data discoverable across your organization

</>

Turn your code into a shareable catalog

Give business users and other analysts visibility into your data model, enabling them to answer data questions quickly.

</>

Understand lineage between tables

Get an quick visual overview of how your tables and views depend on each other.

Adopt DataOps best practices

Dataform is designed for enterprise scale.

Develop in a web based IDE

Create feature branches, commit and pull new changes and run push to GitHub / GitLab for review. Isolate development work from production data

Push all your changes back to Git

All your SQL code, tests, pipelines, schedules and environments are centralized in your Git provider and managed like a normal code base.

Automatically deploy your changes with CI/CD

Dataform watches your Git repository for changes and deploys continuously. Configure multiple environments, schedules, releases, and get alerts when data quality checks fail.

Make sure your warehouse is kept to date

Dataform runs your pipelines to publish views, tables and execute operations to make sure your data warehouse is always up to date.

Getting started is easy

Connect to your warehouse and publish your first data model in 5 minutes.