Load when creating Materialized Views for real-time aggregation, ETL pipelines, or query optimization.
Prerequisite: Understand MergeTree engine variants in clickhouse-schema-design skill.
Search terms: materialized view, MV, real-time aggregation, AggregateFunction, -State, -Merge, SummingMergeTree, pre-aggregation, incremental
10+ patterns for ClickHouse Materialized Views. Load when creating MVs for real-time aggregation, data transformation, or query optimization. Covers SummingMergeTree, AggregatingMergeTree, and common pitfalls. Source: obsessiondb/clickhouse-plugin.