1 min readJun 9, 2022
This project of mine tries to combine the best of both worlds. The Snowflake sql scripting syntax plus conditionals. With that you can build scripts that do an initial deploy of the must recent version, upgrade all database objects from the instance version to the most recent version, create and run tests on the data easily.
Plus dependency handling via various ways, plus schema aliases (to deploy the same code in the same database but different schemas), plus…
Like:
If table xyz does not exist then run this script section.
else check if column abc exists and if not run the alter-table-add-column.
