How to Handle Change Management for Dimensional Data Models

This article discusses the challenges of managing change in production data models, focusing on consistency and transparency. It presents three approaches to deploying changes to models: running transforms directly against a production analytics database, blue-green deployments, and making blue-green deployments more robust by supporting partial subgraph deployments. The article also provides practical examples for dbt users in identifying affected subgraphs for node failures.