ClickHouse

Component Category

OLAP

Component Description

ClickHouse is the analytical database used in ProAI for high-performance querying and OLAP-style workloads. It is a column-oriented engine designed for fast aggregation, low-latency analytics, and large-scale dataset exploration.

Why It Is Used

It provides the analytical storage layer for querying large datasets efficiently and supports reporting and BI workloads that sit beyond the CoreAI application layer. Its design is well suited for real-time analytics, dashboarding, and large-volume query patterns where traditional transactional databases are not the right fit.

Learn More

• ClickHouse Documentation
• ClickHouse on GitHub

Interacts With

• Superset as the main BI consumer in the current ProAI architecture
• Airbyte as an ingestion path into analytical datasets
• Selected wider platform services that also use ClickHouse-backed analytical storage
• Runtime storage, delivery, and operational services that support the cluster deployment