Cool article! I like the practical advice on managing schema changes. I hope you don't mind me sharing on other platforms. Thank you!
Disclaimer: I work at ClickHouse.
Author here, thanks! Feel free to share it on other platforms. Let me know if you have any questions.
Really great stuff. It's a pain to do schema management with clickhouse when materialized views start coming into the picture.
Thanks Randal! I hope to be able to complete a follow-up post on how to automate most of the schema changes by utilizing a form of data contract with the data owner of each metric table. It is very easy to roll out incorrect changes when working with the materialized views in a sharded ClickHouse table due to the need to having to toggle the materialized view and distributed tables when changing the underlying long-term storage tables.