DEV Community

Discussion on: How Do I Monitor Schema Changes in a Data Warehouse?

Collapse
 
andrew_tan_layline profile image
Andrew Tan

Comparing hashes to detect schema drift is pragmatic, but the real pain usually starts when a column type change causes existing queries to start producing nulls silently. Have you tied this monitoring into your CI pipeline so the pull request gets blocked before the migration even lands?