v1.1.55

This release is very special as its packed with a back story of going through challenges of COVID-19 and support for two major cloud datawarehouse platforms Redshift and Snowflake. In this release, we're also able to support diverse transaction modes so we can run either in transaction for run session, for every version, or for every sql statement. The capability enables us to better track migration failures on databases that do not support full transactional DDL such as MySql and Snowflake.

Thank you and looking forward for continuous feedback and issue tickets. This tool only gets better with community of users sharing their issues and feature requests. Inside the box are…

Breaking changes

• Renamed version tracking table into __yuniql_schema_version. Automatic backup and upgrade of __yuniqldbversion existing tables on your next run.

New features & enhancements

• PREVIEW! Support for Snowflake Cloud DW
• PREVIEW! Support for AWS Redshift Cloud DW
• Sequence number in bulk CSV files ensure right order of CSV files
• Diverse transaction modes per session, per version and per statement
• Requires --require-cleared-draft option on yuniql run
• Richer schema history infromation with duration and error information
• Pretty print run configuration for better debugging
• Dedicated yuniql/yuniql Dockerhub image repository
• New CLI command yuniql platforms
• Major refactoring, code cleanup and better test coverage
• Many many bug fixes, prettier console and code improvements

Credits

Special thanks to @bymse, @TaurahSP, @wcontayon and @DavidHopkinsFbr for your significatn contrubutions in this release. Also for everyone filing issue tickets and asking questions, thanks for all your feedback.

Sneek Peek

Amazon Redshift rapid database deployment and schema versioning with yuniql - preview
https://www.youtube.com/watch?v=TUJijZsXP7k