A SQL-Based Metrics Layer for DuckDB and Clickhouse

The ability to aggregate raw data into summarized metrics and slice them across dimensions is at the core of analytics teams' work. This session reveals how Rill has developed a metrics layer that declares metrics entirely with SQL expressions, overcoming traditional limitations of metrics management. By leveraging DuckDB and Clickhouse, attendees will discover how to generate multi-dimensional OLAP cubes, implement real-time data access with sub-second performance, and create uniform dashboards through a BI-as-code philosophy. Learn how to define, manage, and secure metrics using an innovative SQL-based approach that transforms raw data into powerful, actionable insights.