Database Change Management (DCM) Projects, now in public preview, bring declarative infrastructure management to Snowflake. And the dcm skill in Cortex Code turns that power into an AI-guided workflow — from first file to first deployment. You describe what your infrastructure should look like, Cortex Code helps you write the definitions, the DCM skill helps you validate them before a single object changes, and DCM handles deployment across your environments.
Managing infrastructure at scale is hard
Schema drift is quiet. Pipelines built on tables managed by ALTER TABLE scripts grow out of sync the moment two engineers touch the same object from different branches. Multi-environment deployments — dev, staging, prod — mean duplicating logic and hoping the config variables stay consistent. And when something breaks, the downstream impact is bigger than it looks.
The traditional fix is rigid: migration scripts, heavy CI/CD tooling, external state stores. These work, but they add friction for every change. Data engineers spend more time tracking what was deployed than building what matters.
DCM Projects solve this with a different model. Instead of scripting changes, you declare what each object should look like using DEFINE syntax. DCM computes the diff, shows you an execution plan before anything runs and applies only what's needed.
