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!

Features
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.

As always if you have any feedback on features please message us on Slack or email us at team@dataform.co

More content from Dataform

What can data teams learn from Google’s State of DevOps report? illustration
Opinion

What can data teams learn from Google’s State of DevOps report?

Google's research shows us that elite engineering teams have a lot in common when it comes to DevOps. We think similar principles apply to data teams or, more precisely, DataOps.
Learn more
Cut data warehouse costs with run caching illustration
Product Update

Cut data warehouse costs with run caching

How to save time and money by using our run caching feature
Learn more
Building the Dataform VS Code extension illustration
Guide

Building the Dataform VS Code extension

How we made our own extension for Visual Studio Code.
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.