A capstone project (BU EC528, in collaboration with State Street) that automates the deployment and management of Snowflake resources through CI/CD pipelines. The system orchestrates creation, modification, and deletion of databases, schemas, users, roles, and warehouses using Liquibase for migration version control and Harness for CI/CD orchestration. We implemented role-based access control to safeguard credentials, built automated warehouse scaling scripts, and packaged the workflow into a reusable CLI tool ("Snowpilot") to broaden adoption beyond the original team. Cortex/ML integration was added to support advanced analytics on top of the managed Snowflake environment.

• PlatformCloud Data Warehouse Automation
• StackSnowflake, Liquibase, Harness, Python, Docker, Git
• CapabilitiesCI/CD pipelines with rollback, RBAC, automated warehouse scaling, Snowflake Cortex/ML, Snowpilot CLI
• TeamBU EC528 capstone — 5-person team mentored by State Street engineers