We are pleased to announce version 0.2.0 of SQL Runner. SQL Runner is an open source app, written in Go, that makes it easy to execute SQL statements programmatically as part of the Snowplow data pipeline.
To use SQL Runner, you assemble a playbook i.e. a YAML file that lists the different
.sql files to be run and the database they are to be run against. It is possible to specify which sequence the files should be run, and to run files in parallel.
Read on after the jump for:
For more information on SQL Runner please view the GitHub repository.
1. New features
The main addition is the ability to run SQL against Redshift and Postgres databases which have SSL security enabled. Many thanks to Dennis Waldron from Space Ape Games for contributing this feature!
Update the database targets in your playbooks to use the new
Other updates in this version:
- Fixed typo of “queries executed againt targets” (#20)
- Updated vagrant up to work with latest Peru version (#25)
- Replaced bitbucket.org/kardianos/osext with github.com/kardianos/osext (#33)
A version of SQL Runner for 64-bit Linux is available on Bintray, download it like so:
Once downloaded, unzip it:
Run it like so:
Remember to update your database targets in playbooks to use the new
3. Getting help
For more details on this release, please check out the SQL Runner 0.2.0 release notes on GitHub.