Version control your SQL code | Dataform
Product Update

Version control your SQL code

How Dataform allows you to version control your SQL and our new Git commit UI!

picture of author

Josie Hall on December 10, 2019

Collaboration on data pipeliens is hard. Often one analyst will make a change to a dataset, write a new query or create a new view, when other members of the team aren't aware. This can result in reports/ dashboards breaking and can quickly become an issue.

Dataform uses the Git version control system to maintain a record of each change made to project files and to manage file versions. Each Dataform project has an associated Git repository, allowing you to easily version control your database.

One of the main benefits of Git is that a developer can work in an isolated "branch" of the file repository without affecting the base files. Dataform has full support for Git branches. Once you are happy with your changes, you can commit them and push them to the master branch. If at any point you make changes that you don't want to commit, you can revert your branch to its last commit.

This means the whole team can collaborate on a single code base. Data teams can implement code review processes and collaborate effectively as a team, ensuring work is not duplicated and pipelines don't break.

New git modal in Dataform

We’ve created a modal which makes it very easy to see an overview of the changes you’ve made to your project before committing them to your branch.

You can read more about version control in Dataform in our docs here.

More content from Dataform

Dataform is joining Google Cloud


Dataform is joining Google Cloud

Today we're excited to announce that we've joined Google Cloud. Over the course of the past several months, our partnership with Google Cloud has deepened and we believe that our new combined efforts can make our customers and partners even more successful.
Learn more
Using Javascript to Create an Acquisition Funnel Dataset illustration

Using Javascript to Create an Acquisition Funnel Dataset

How to use a combination of SQL and Javascript to create an acquisition funnel dataset.
Learn more
How to add a new warehouse adapter to Dataform illustration

How to add a new warehouse adapter to Dataform

I recently wrote a Presto adapter for Dataform during a week long quarterly hackathon. Here's a guide on how I'd do it again.
Learn more

Learn more about the Dataform data modeling platform

Dataform brings open source tooling, best practices, and software engineering inspired workflows to advanced data teams that are seeking to scale, enabling you to deliver reliable data to your entire organization.