Repository files navigation

Rill delivers the fastest path from data lake to dashboard.For data engineers and analysts, it provides rapid, self-service dashboards built directly on raw data lakes, eliminating traditional BI complexity.For data consumers, it ensures reliable, fast-loading dashboards with accurate, real-time metrics.

Download Rill to start modeling data and create fast, exploratory dashboards in minutes:

curl https://rill.sh| shrill start my-rill-project

Unlike most BI tools, Rill comes with its own embedded in-memory database powered by DuckDB or ClickHouse. Data and compute are co-located, and queries return in milliseconds, so you can pivot, slice, and drill-down into your data instantly.

We also support bringing your own OLAP engine as a live connector with pushdown compute capabilities.

• Table of Contents
• Rill's design principles:
• Core Concepts
  • BI-As-Code
  • Metrics Layer
  • AI Agents
• Learn More
• Production Examples
  • Programmatic Ads/OpenRTB
  • Cost Monitoring
  • GitHub Analytics
  • App Engagement
  • Kitchen-sink example
• Get in touch!
• Company
• License

• Lightning Fast - Powered by SvelteKit & DuckDB for conversationally fast performance
• Universal Data Support - Works with local and remote datasets (Parquet, CSV, S3, GCS, HTTPS, local)
• Automatic Profiling - Build intuition about your dataset through automatic profiling
• Real-time Response - Responds to each keystroke by re-profiling the resulting dataset
• Interactive Dashboards - Thoughtful, opinionated defaults for quick insights
• Dashboards as Code - Version control, Git sharing, and easy project rehydration

Rill implements BI-as-code through a combination of:

1. SQL-based Definitions: Define your models via SQL to connect to your various sources
2. YAML Configuration: Configure your metrics views, dashboards, and project settings via YAML
3. Git Integration: Version control your analytics assets
4. CLI Tools: Deploy and manage your analytics stack from the command line

Rill's metrics layer provides a unified way to define, compute, and serve business metrics. Metrics views combine SQL models with YAML configuration to create standardized, reusable business metrics that can be consumed by dashboards, APIs, and AI systems.

Example Metrics View:

# metrics/revenue_metrics.yamlname:revenue_metricsdescription:Key revenue metrics by country and productmodel:revenue_modeltimeseries:datedimensions:  -name:countrycolumn:country  -name:product_categorycolumn:product_categorymeasures:  -name:total_revenueexpression:sum(amount)description:Total revenue amount  -name:order_countexpression:count(*)description:Number of orders  -name:avg_order_valueexpression:sum(amount) / count(*)description:Average order value

We understand the critical importance of AI and data in modern business intelligence. Our metrics layer is designed to provide AI systems with the structured, real-time data they need to deliver quick and accurate responses. By co-locating data and compute with embedded databases like DuckDB and ClickHouse, Rill eliminates the latency that traditional BI tools introduce, ensuring AI agents can access fresh metrics instantly for precise decision-making and intelligent automation.

For visual learners, take a look at our various playlists that explains what Rill is and how to get the most out of it!

Bidstream data for programmatic advertisers to optimize pricing strategies, look for inventory opportunities, and improve campaign performance.

• GitHub →
  
• Walkthrough →
  
• Live Demo →

Based on Rill's own internal dashboards, cloud infrastructure data (compute, storage, pipeline statistics, etc.) merged with customer data to analyze bottlenecks and look for efficiencies.

• GitHub →
  
• Walkthrough →
  
• Live Demo →

Analyze GitHub activity to understand what parts of your codebase are most active, analyze contributor productivity, and evaluate the intersections between commits and files.

• GitHub →
  
• Walkthrough →
  
• Live Demo →

A conversion dataset used by marketers, mobile developers, or product teams to analyze funnel steps.

• GitHub →
  
• Live Demo →

A compilation of projects with deep dives into Rill's features using ClickHouse's GitHub commit information.

• GitHub →
  
• Walkthrough →
  
• Live Demo →

• Discord Community - Join discussions and get help
• GitHub Issues - Report bugs and request features
• Rill Guru - Ask questions and get expert answers

Rill is developed and maintained byRill Data, Inc..

This project is licensed under theApache License 2.0 - see theLICENSE file for details.