A SQL Based Metrics Layer for DuckDB and ClickHouse @aicouncilconf
A SQL Based Metrics Layer for DuckDB and ClickHouse  @aicouncilconf
Uploaded May 2025 | Updated November 2026, 1 hour ago
[2025 - Day 2 - Analytics & BI] Mike Driscoll shares insights from building Rill's SQL-based metrics layer using DuckDB, exploring how to aggregate raw data into summarized metrics and enable dimensional slicing through declarative SQL expressions. This talk offers valuable perspectives on implementing fast OLAP engines for real-time data access with sub-second response times, essential for analytics teams seeking to define metrics using familiar SQL dialect as part of a BI-as-code philosophy.

ABOUT THE SPEAKER:
Mike Driscoll, Co-Founder & CEO, Rill Data -

🎟️ GET YOUR TICKET TO AI COUNCIL 2026 🎟️
Meet the world's top AI infrastructure minds where architects of AI share what works. Three days of high-quality technical talks and meaningful interactions.

β†’ aicouncil.com/sf-2026

⚑ FIND US:
X: https://x.com/AICouncilConf
LinkedIn: linkedin.com/company/aicouncilconf
Website: aicouncil.com
A SQL Based Metrics Layer for DuckDB and ClickHouseWhat does the whole orchestration and coordination layer look like from a tooling perspective?How a Netflix Side Project Became the Universal Standard for Data TablesThe Deconstructed Database at DatadogBuilding SOTA Search: It’s Ranking All the Way DownGoing Bayes: Shifting our Testing Methods to Reflect our PrioritiesThe Deconstructed Database and the Advent of the Open Data LakeThe Future of Data Engineering in the Agent EraBuilding Blocks: Advanced Semantic Data Model LayeringHow we made Trail of Bits AI-Native (so far) | Trail of BitsEvals 101: Intro to Evals for Engineers | BraintrustOrchestrating at Scale  How Instacart Manages 20M+ Daily Workflows
AI Council |

A SQL Based Metrics Layer for DuckDB and ClickHouse

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER