Rill is an operational BI-as-code tool built on ClickHouse that processes over 100 billion events per day. It uses a declarative workflow where data sources, transformations, and metrics are defined in SQL and YAML, enabling Git versioning and AI-assisted development with tools like Cursor. ClickHouse serves as the core analytics engine, enabling cache-free real-time drill-downs and interactive analysis. The architecture combines dlt for declarative data ingestion, ClickHouse for high-performance aggregation, and a metrics-first semantic layer that powers dashboards, APIs, and conversational AI analytics with verifiable, traceable results.
166 Impressions