All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.
- PyPI package support so that snowchange can be installed through pip
- Dockerfile for building Docker images
- Allow for .SQL file extensions (common in Windows environments) in addition to .sql extensions
- Support for "repeatable" scripts such as stored procedures, functions etc
- Support for variables in change scripts (following a Jinja expression syntax)! See the README for more details.
- A new optional parameter
--varswhich accepts a JSON formatted string of variables and values (e.g.{"variable1": "value1", "variable2": "value2"})
- Add the Snowflake account name to the script output to provide more log context
- Removed the deprecated
--snowflake-regionparameter. Instead use the-aor--snowflake-accountaccount parameter. See Usage Notes for the account Parameter (for the connect Method) for more details on how to structure the account name.
- Support for cross-database dependencies!
- Support for override the location and name of the change history table with the new parameter
--change-history-table(or-c) - Change log for snowchange project (this CHANGELOG.md file)
- The required project folder structure, removing the database folder convention
- Where the change history table gets created and how it gets named
- The schema of the change history table (removed INSTALLED_RANK and renamed/reordered a few columns)
- Updated the getting started section of the README.md to make the getting started steps more clear
- The ability for snowchange to create user databases directly (now the user must explicity do so in their change scripts)
- The
--environment-nameand--append-environment-nameparameters