An intro to Materialized Views in ClickHouse

Mark Needham Principal Product Marketing Manager, ClickHouse

In this video, we explore materialized views in ClickHouse using a dataset of PyPI download events. Materialized views in ClickHouse don't store data themselves but perform transformations on data as it is inserted. We illustrate this process using the PyPI dataset, showing how it can efficiently aggregate daily download counts per project.