You mentioned materialized views. How did you use them and what were the specific benefits? I agree they are one of the more amazing features in ClickHouse but you can always learn more about how to use them.

Meanwhile Thanks for the post and the shout-outs to Altinity videos!

p.s., I work at Altinity.