“Continuous Integration” with automated unit tests is a widely accepted practice to try to ensure software quality. What about applying the same principle to ensure data quality? If you keep data in a version control system like Git, and already have (or can develop) an automated way to validate this data, you’re almost all of the way there to automatically validating every commit to your data repository.
If your data repository is on GitHub, this is pretty easy to set up with Travis CI. This will also have the added benefit of automatically validating pull requests so you can see if they pass your data validation process before merging. Follow the Getting Started guide for setting up Travis and adding your repository, then configure your
.travis.yml file to run your data validation in the
The main place I’ve been using this in practice is for automated validation of the Papyri.info data repository. This validates all of the main XML files in the repository against their associated RELAX NG schemas using Jing:
I’ve also added a simple JSON validation with JSON Lint to my
You can even do CSV validation with
csvlint (schema optional):
Hopefully these simple examples give you an idea of how to get started and apply the same pattern to your data repositories—even if you aren’t using Travis, the same principle should work for other continuous integration solutions.
Of course, you could also go further than “just” schema validation or linting, and start adding assertions about the data content itself!
You can also this approach to, for example, automatically validate your statically-generated websites with