ClickHouse OLAP

When to Use

Load this skill when the user needs to:

• Design ClickHouse tables for analytical workloads (facts, metrics, logs, events)
• Choose the right MergeTree engine variant
• Optimize queries (ORDER BY design, data skipping indexes, PREWHERE)
• Set up materialized views for real-time aggregations
• Configure TTL for data lifecycle management
• Write Python code with clickhouse-connect or clickhouse-driver

Architecture Overview