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.
Recent videos
View all Videos
How to
CDC ClickPipes: The Fastest Way to Replicate Your Database to ClickHouse
Marta Paes, Senior Product Manager at ClickHouse

How to
Under-the-Hood: ClickHouse Incremental Materialized Views and Dictionaries
Maruthi Lokanathan, Solution Architect at ClickHouse Derek Chia, Principal TAM Architect at ClickHouse

ClickHouse Cloud, How to
LogHouse, Observability for ClickHouse Cloud
Get an insider’s look at LogHouse, the ClickHouse-powered logging platform that drives observability for ClickHouse Cloud.

ClickHouse, How to
Powering Feature Stores with ClickHouse
Mark Needham Principal Product Marketing Engineer, ClickHouse