ClickHouse Analytics & Engineering

This skill provides specialized guidance for architecting and optimizing ClickHouse databases for high-performance analytical processing (OLAP). It includes comprehensive patterns for table engine selection like the MergeTree family, advanced query optimization techniques, and efficient data ingestion strategies for both batch and streaming workflows. By applying these patterns, developers can implement real-time aggregation with Materialized Views and execute complex analytical queries—such as funnel, cohort, and retention analysis—on massive datasets with sub-second latency.

主要功能

使用场景