Dataset versioning: safely update schemas
Once you are querying datasets in production, reliability is paramount. One of the most common issues is something breaking or changing upstream, such as a source table schema. Data engineers and product developers could simply coordinate these changes in lockstep, but this tightly couples teams and remains error prone.
Patch now supports a versioning workflow to safely update source tables & schemas, while continuing to serve production traffic. Simply run the following command, update your dataset, and Patch will increment the version. Then, you can write queries against the new version in your dev environment, while the previous version continues to serve traffic with fresh data. Once you're done testing, simply promote the new code and version to production. Learn more in our docs!
$ pat dataset update <my_dataset_name> --edit-tables
...
Dataset update submitted! Your dataset will now be updated to version 2.