Blog
Rill’s Agentic Architecture: Analytics for the AI Era
From prompt hacks to a unified agentic runtime for analytical work.
Feeding the agentic beast: Building a data stack that AI loves
At Rill, we’ve been building for high-concurrency, high-volume analytics workloads from the start. In this post, I’ll focus on the semantic layer — because in agentic analytics it’s the only layer that can simultaneously understand user intent, data topology, and execution cost.
Introducing Metrics SQL: A SQL-based semantic layer for humans and agents
When we built Rill, we made a bet that metrics – concepts like revenue, MAU, ROAS — are the core primitive for semantic layers. This blog post is a deep technical dive into how Rill's Metrics SQL
Video: Building Fast Agentic Analytics with Google Antigravity and Rill
In this walkthrough, we explore how developers and data teams can use the combination of Rill Data + Google Antigravity to build, modify, and scale analytics workflows entirely in code.
AI Reveals Why BI Still Matters (Hint: It’s Not Dashboards)
This blog looks at how BI evolved, how dashboards are actually used today, and what survives when AI enters the picture — starting with the foundation that was never really about dashboards in the first place, and ending with the problem nobody in the AI hype cycle wants to talk about: who maintains it all.
How the Weights & Biases Cofounder Created One of AI's Defining Exits
Mike Driscoll interviews Lukas Biewald, co-founder of Weights & Biases. In this conversation, he traces the full arc: from an unpaid internship at a 30-person OpenAI to building one of the definin
Video: Building Fast Agentic Analytics with Cursor and Rill
Walk through of how Rill enables a fully agentic BI workflow using tools like Cursor, local development environments, and modern CI/CD practices — all while delivering instant, production-ready insigh
Building an Agent-Friendly, Local-First Analytics Stack with MotherDuck and Rill
The convergence of embedded analytics engines (DuckDB/MotherDuck), declarative BI-as-code (Rill), and AI agent protocols (MCP) is creating a new architecture for business intelligence, one where dashb
Video: Building Fast Agentic Analytics with Claude Code and Rill
Learn how to build fast agentic analytics using Claude Code and Rill. Discover how AI coding agents and developer-first BI enable faster metrics, dashboards, and analytics workflows.
Why Coinbase and Pinterest Chose StarRocks: Lakehouse-Native Design and Fast Joins at Terabyte Scale
Discover why Coinbase and Pinterest migrated to StarRocks for sub-second analytics. Learn how its lakehouse-native design and colocated joins handle terabyte-scale data on S3.
Python Was Built for Humans. AI Just Changed Everything.
Wes McKinney, creator of Pandas & co-creator of Apache Arrow, explains his unexpected switch from Python to Go for new projects. His reason: AI coding agents fundamentally changed the trade-offs t
How ClickHouse became one of the fastest-growing databases in the world
Alexey Milovidov — co-founder & CTO of ClickHouse — joins Michael Driscoll to break down why ClickHouse has become one of the fastest-growing databases in the world. This conversation goes deep on
The Semantic Layer Problem Nobody Wants to Talk About
Lloyd Tabb — creator of Looker and co-founder of Malloy — joins Rill Data Co-Founder & CEO Michael Driscoll to unpack one of the most misunderstood problems in modern data engineering. From low-la
Rill in Review: Top Features That Shaped 2025
As the year closes, it's the perfect time to reflect on how Rill has grown and the features that made the biggest difference. Over the past year, we shipped improvements focused on making analytic
DuckDB Won By Refusing to Scale Out
Hannes Mühleisen — creator of DuckDB — joins Rill Data Co-Founder & CEO Michael Driscoll to explain why DuckDB has become one of the fastest-growing databases in the world.
dlt+ClickHouse+Rill: Multi-Cloud Cost Analytics, Cloud-Ready
FinOps Made Easy: A Starter Repo to Oversee Cloud Costs from Different Hyperscalers.
The Modern Data Stack Is Over. Here’s What’s Next.
Matthaus Krzykowski — co-founder & CEO of dltHub — joins Rill Data Co-Founder & CEO Michael Driscoll to break down one of the biggest shifts happening in data engineering right now.
Multi-Cloud Cost Analytics: From Cost-Export to Parquet to Rill
Learn how to unify AWS and GCP costs with revenue data in a single dashboard. Step-by-step guide using dlt, Parquet, and Rill. Clone and run immediately.
The Great Reset: How AI Is Forcing Data Teams Back to Zero
Joe Reis joins Michael Driscoll to break down what he calls The Great Reset—a moment where AI shockwaves, consolidation, and collapsing toolchains have erased the advantages data teams spent a decade building.
Data Modeling for the Agentic Era: Semantics, Speed, and Stewardship
Master the three pillars of agentic data modeling: Metrics SQL for semantics, sub-second analytics for speed, and AI guardrails for trusted insights.
Data Modeling Guide for Real-Time Analytics with ClickHouse
Learn how to build sub-second real-time analytics with ClickHouse. Complete guide covering data modeling strategies, optimization techniques, and practical S3-to-dashboard examples.
Data-Driven Leader Series - Episode 2 - Digital Turbine
Glenn and Mike dive deep into old world vs new world analytics with specific examples of how Rill helps Digital Turbine achieve speed and efficiency.
Data Engineering Postcard Series
A comprehensive curated list of data engineering resources. Features trending topics like lakehouse architectures, declarative data stacks, and rising tools such as DuckDB and ClickHouse.
Top 10 tips for using Claude Desktop with Rill Data
To get the most out of your data conversations, we've compiled a list of our top 10 tips. Get connected, try them out, and let us know if you find any new techniques!
Has Self-Serve BI Finally Arrived Thanks to AI?
How conversational BI and MCP deliver on two decades of promises
Data-Driven Leader Series - Episode 1 - Disco
In our inaugural episode of our Data-Driven Leaders Series, we interview Kat Tomlin, Director of Business Operations at Disco.
Data Talks on the Rocks 8 - ClickHouse, StarTree, MotherDuck, and Tobiko Data
Michael Driscoll discusses real-time databases and next-generation ETL with a legendary panel of technical founders from ClickHouse), StarTree, MotherDuck, and Tobiko.
The Open Table Format Revolution: Why Hyperscalers Are Betting on Managed Iceberg
This blog explores the four layers of the ICE Stack, from storage to catalogs, and why managed Iceberg might represent the post-Modern Data Stack future where data independence truly matters.
Introducing Canvas dashboards — a new way to visualize metrics
We’re excited to introduce Canvas dashboards, a flexible way to arrange and visualize your metrics however you’d like.
What "Shifting Left" Means and Why it Matters for Data Stacks
By shifting left, data teams can create more maintainable, performant, and reliable data systems while reducing duplication and inconsistency throughout the data stack.
Data Talks on the Rocks 7 - Kishore Gopalakrishna, StarTree
This video interview covers Pinot's architectural decisions and actual use cases from Uber, Stripe, and Walmart. It also highlights in depth details on Pinot's real time benefits of freshness, latency, and concurrency.
Scaling Beyond Postgres: How to Choose a Real-Time Analytical Database
This blog explores how real-time databases address critical analytical requirements. We highlight the differences between cloud data warehouses like Snowflake and BigQuery, legacy OLAP databases like Vertica, and a new class of real-time analytical databases like ClickHouse and StarRocks that combine elements of both of these categories. We will also examine the categories of today's analytics solutions and how to choose the right one.
Why You Need a SQL-based Metrics Layer
Once metrics are defined with SQL expressions, we automatically generate an exploratory dashboard -- enabling slicing, dicing, and drill down across any dimension.
Why Pivot Tables Never Die
This blog explores why pivot tables have endured for over decades, how they evolved in the AI era, and why they might be the key to making business intelligence (BI) accessible to everyone.
Designing a Declarative Data Stack: From Theory to Practice
This blog chronicles that journey of discovery, examining the key architectural considerations and trade-offs in building a declarative data stack and its engine. We'll explore existing approaches, compare different implementation strategies, and work through practical examples
2024 Product Recap - 5 Top Features
In 2024, we launched more features than we can count and together with our customers solved interesting and challenging data problems. Alex Thor, Product Manager, shares his top 5 features we shipped this year.
Data Talks on the Rocks 6 - Simon Späti
In a conversation with Simon Späti, we explore Bluesky’s open social graph, DuckDB’s rise, declarative data systems, and the enduring importance of data modeling.
BI-as-Code and the New Era of GenBI
Imagine creating business dashboards by simply describing what you want to see. This is the promise of Generative Business Intelligence (GenBI). The key lies in the declarative BI stack where dashboards and metrics are defined as code rather than hidden behind graphical user interfaces.
The Rise of the Declarative Data Stack
The future looks more code-first. From ingestion to transformation, orchestration, and measures in dashboards—all defined declaratively. But what does this shift actually mean?
Video: How Rill powers fast, exploratory dashboards with ClickHouse
This presentation was given at a ClickHouse meetup in San Francisco on June 4, 2024
Introducing the new File Explorer
With the File Explorer, developers now have the ability to interface with their entire Rill project natively and restructure the project, including assets and nested folders, to better align with the needs of their use cases or organization.
Introducing the Rill pivot table
The pivot table is the most popular tool in data exploration, analysis, and reporting software. Given their widespread popularity and utility, we’re proud to now introduce pivot tables to Rill.
ClickHouse dashboards with Rill: instant, operational BI at scale
Why not scale up Rill using ClickHouse? We're excited to announce our live connector for ClickHouse. Now it’s possible to build interactive, exploratory, embedded ClickHouse dashboards.
GenBI - one-click dashboards with generative AI and BI-as-code
Rill’s open-source IDE, uses AI to transform an S3 data source into an operational dashboard in one click. This creative magic is made possible by combining (1) Rill’s BI-as-code philosophy defines dashboards entirely with SQL & YAML code and (2) Large language models, like OpenAI’s GPT series, excel at code generation
2023 Product Recap - 6 Big Features
2023 has been a wild year for Rill. We have made tremendous improvements into the product. Here is a list of our top features from 2023.
Data Talks on the Rocks 2 - Vercel and Tabular
Fireside chat with the founders of Vercel and Tabular
Data Talks on the Rocks 1 - Modal Labs, Pinecone, Ask-Y
Vibrant panel discussion featuring Edo Liberty, Erik Bernhardsson, and Katrin Ribant
Lessons Learned in Developing Interactive Time Exploration in Rill Dashboards
Time is an integral component of data analysis. Learn about how Rill is built to handle the complexity of time in modern data visualization.
Fast DuckDB-Powered Dashboards with Rill and MotherDuck
Connect MotherDuck with Rill to help your team visualize data and draw timely insights with fast, exploratory dashboards.
Analyze Your GitHub Repository with Rill
Your GitHub data has countless insights waiting to be discovered. Learn how you can build your own GitHub analytics dashboard in minutes with Rill.
Introducing Rill Cloud: The Fastest Path from Data Lake to Dashboard
Deliver fast, exploratory dashboards in minutes. Install Rill, connect to your S3 or GCS bucket, build SQL-defined dashboards, and deploy to Rill Cloud.
The Journey from Metamarkets to Rill
We hosted a webinar with Michael Driscoll and Hammond Guerin, Sr. Director of Analytics at Liftoff to share how the Metamarkets solution for interactive ad tech dashboards has been reimagined into a new solution called Rill.
Why We Built Rill with DuckDB
The data community is obsessed with DuckDB - and so are we. It’s the perfect engine to power Rill, our conversation-fast data profiling and dashboard tool.
Accelerating the Core Analysis Loop
Achieve flow in your work with tools that bring data insights at the speed of conversation.
How to Create Roll-ups in Apache Druid
Neil Buesing crafted four hands-on examples of common Druid roll-up scenarios: roll-up comparison, Kafka ingestion, DataSketches, and custom time granularities.
Seeking the Perfect Apache Druid Rollup
Apache Druid Rollups improve storage and query performance. Keep these 8 important concepts in mind to use rollups effectively and avoid mistakes.
Apache Airflow for Orchestration and Monitoring of Apache Druid
For pipeline management of critical applications, consider the lifecycle of your data. Use this conceptual framework to identify potential issues as early in the lifecycle as possible.
Apache Airflow for Orchestration and Monitoring of Apache Druid
Monitoring the health of data pipelines and the underlying infrastructure-supporting applications and dashboards is mission critical for operational analytics. Learn how to set up our observability architecture using Apache Airflow integrated with Opsgenie and Slack.
Fast Path to Streaming Data Analysis
This blog is a step-by-step how-to demo for streaming data into Rill’s platform for sub-second analysis. We selected aircraft telemetry data to answer time-series analytical questions.
The Guide to Apache Druid Architectures
A list of articles, customer stories, and reference architectures that best helped our team get up to speed learning about Apache Druid...
Setting up Apache Druid on Kubernetes in under 30 minutes
Kubernetes is an orchestration engine which can run and manage containerized applications. Each application has different ways to autoscale...
Guide: Connect Looker to Druid and explore your data in real time
This is a step-by-step guide on how to leverage Looker’s modeling and ad-hoc analytics with the performance of Druid to generate an operational analytics experience that is fast and interactive.
5 Founders on building authentic data communities
Part 3 of our Modern Data Stack panel posed the question: "How do you build a data community that is authentic and real?" We considered the differences between audiences and communities, as well as differences between developer and user communities.
5 Founders on the biggest unsolved problems of the Modern Data Stack
This next segment of the Modern Data Stack event had five data company founders respond to "the largest unsolved problems in modern data." They considered: What is the ROI of data, or of a dashboard? How do we reduce complexity? and more...
5 Founders define the Modern Data Stack
What does the "Modern Data Stack" really mean? What does it include? We hosted an in-person event in San Francisco to discuss the Modern Data Stack—ETL pipelines, quality monitoring, operational analytics, fast OLAP stores, headless BI, and more...
Guide: Connect Druid to Tableau for sub-second dashboards
Leverage the speed of Druid in either a purpose-built analytics deployment or with the ease of your favorite analytics tools. If you have Tableau, use this short guide to walk you through connecting Tableau to Rill’s public Druid cluster.
How to achieve fast query speed with no DevOps maintenance
The transition from on-prem to cloud has picked up speed. While just five years ago, companies were resisting moving to the cloud due to data security concerns, the more common question now is, “How can I move to the cloud as quickly and cost efficiently as possible?”
Introducing Rill Data’s BigQuery Connector
Apache Druid is an open source tool that comes with a standard set of connectors to ingest data from Kafka, Amazon S3, Google Cloud Storage, and Azure, and now with Rill Data ... BigQuery.
Druid + Looker? Druid + Tableau? Leverage data interoperability for data visualization
If you are designing an analytics stack, it’s important to stay flexible. When it comes to analytics, you may choose a data warehouse such as BigQuery or Snowflake for periodic reporting on historical data, and you may choose an operational database.
Apache Druid and Rill: better together
Apache Druid is an open source data store designed for high performance (sub-second) OLAP queries on large (terabyte) datasets. Learn how you can experience all of the benefits of Apache Druid's high performance real-time analytics database without the maintenance.
When should I use Apache Druid? Try this checklist.
Apache Druid is purpose built to generate high performance at low cost on a set of use cases that are becoming increasingly common: Operational Analytics. We've assembled the "Apache Druid Optimal Characteristics Checklist" to make it easy to understand the costs and benefits of using Druid for your use case.
Apache Druid Turns 10: The Untold Origin Story
Ten years ago today, the Druid data store was introduced to the world by Eric Tschetter, its creator, working at a small start-up named Metamarkets. Eric had left LinkedIn six months earlier to join us as the first full-time employee, and I was the CTO and co-founder, working ...
Operational intelligence and the new frontier of data
At Rill, we believe the need for operational intelligence will dramatically expand in the coming years. In this post we lay out why operational intelligence matters now, its salient differences with traditional business intelligence, and why it demands new technology architectures.
Showing 9 of 71 posts