Skip to content

Materialized Views

No access code required


In this course, you'll learn how to: 

  • define a simple view and a materialized view in ClickHouse
  • create a materialized view that keeps a running total of numeric columns
  • how to aggregate columns using the AggregatingMergeTree table engine
  • work through examples that follow the recommended usage of materialized views, including using the TO clause and populating a view without losing data

This course also includes hands-on lab exercises.