From the course: Advanced Data Engineering with Snowflake

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Database change management (DCM)

Database change management (DCM) - Snowflake Tutorial

From the course: Advanced Data Engineering with Snowflake

Start my 1-month free trial Buy for my team

Database change management (DCM)

“

Let's now imagine that we need to introduce changes to our pipeline. How do we do that in a way that minimizes risk to the end user? We'll do this through a combination of source control and using a declarative approach for managing database changes. Before implementing this approach, let's understand a couple of common approaches to managing database changes. The practice of managing changes to database objects is cleverly known as Database Change Management or DCM. The terms Database Schema Migration and Schema Change Management are synonymous as well. My colleague, Jeremiah Hansen has what I feel is a clear and comprehensive definition of this practice. He says, "Database Change Management, DCM, is the practice of defining all database objects in code, in a Git repository, and then deploying those objects, including changes to those objects, to a database with the help of a dedicated tool." This exercise will cover the first half of that definition, namely, defining objects in code…

Contents