Chris Metcalf
posted this on September 21, 2011 12:16
The Publishing Workflow changes some of the fundamental ways in which datasets work on Socrata. Instead of being a dataset being an always-live representation of your data - where consumers see changes or updates you make in real time - datasets will have two states: Published and Working Copy
A Published dataset is a static, locked copy of your data intended for sharing either with the public or within your organization. It represents a particular version of your dataset, and thus is locked against editing. In order to make edits to your datasets, you must first create a Working Copy.
A Working Copy is an editable version of your dataset that is distinct from the Published copy. Think of it as an internal draft copy of your dataset that you can collaborate with your coworkers on. You can make whatever changes you want to the Working Copy without those changes being reflected in the Published copy. When you’re done with making your changes, you can “publish” the Working Copy to be the new Published Copy, and your changes will become live. Even better, the old Published Copy becomes a Snapshot (if your platform configuration includes that feature), which you can reference as a historical version of the dataset.

There are many benefits to the Publishing Workflow, but here are a few of our favorites:
Published copies can be heavily cached, allowing us to improve the performance of datasets both large and smallWorking Copy without affecting the Published copy, you have a chance to review updates for correctness, clarity, and completeness before they go live. You can even share them within your organization to get approval before the changes are published. No longer will you have to fear that the changes or updates you’re making will break your dataset!Snapshots (as available in your platform configuration), and even accessible via the Consumer API, you can keep historical archives of your dataset around to show how it has changed over time.The Publishing Workflow does have a few effects on your dataset management process:
Working Copy . Before you can make your dataset public, you'll need to publish your dataset to make a Published Copy for the public to access.Working Copy to make your modifications against.