overview

when i worked with state street corporation as a part of Boston University’s cloud computing class (ENG EC 528), i built a system to automate resource deployments (orchestrating database migrations) from snowflake over the course 4 months.

this project exposed me to the inner workings of ci/cd pipelines and cloud-native deployment, in addition to how database migrations truly work.

stack

  • we used python (and pytest) for the backend, because of its easy-to-learn orm structures and its cohesion with liquibase.
  • we used Harness to orchestrate ci/cd pathways and manage deployments.

architecture

snowflake architecture

this figure shows the overall architecture of our project, detailing the specific functions of liquibase and harness.