Rill is a code-first business intelligence platform designed for fast, interactive exploration of operational data.
Projects are largely described using SQL and YAML, making analytics definitions easy to keep under version control and review alongside other code. Rill can connect to databases, cloud object storage, warehouses, and other data sources, then transform the data and expose reusable dimensions and measures through its metrics layer.
Its dashboards emphasise rapid filtering, slicing, pivoting, and drill-down. Rill can use DuckDB for local analytics and supports ClickHouse-backed workloads, while its command-line tooling provides a local development environment for building and previewing projects before deployment.
This is free and open source software.
Key Features
- Code-first projects defined primarily with SQL and YAML.
- Connectors for databases, data warehouses, and object storage.
- DuckDB-powered local analytics.
- Support for ClickHouse-backed analytics workloads.
- Models for transforming and preparing data.
- Semantic metrics layer with reusable dimensions and measures.
- Interactive dashboards for filtering, pivoting, and drilling into data.
- Canvas dashboards for building customised analytical views.
- Data profiling for inspecting columns and distributions.
- Incremental and partitioned data processing.
- Row-level access policies for controlling data visibility.
- Git-friendly workflow with a local development environment and CLI.
Website: github.com/rilldata/rill
Support:
Developer: Rill Data, Inc
License: Apache License 2.0
Rill is written in Go and TypeScript. Learn Go with our recommended free books and free tutorials.
Related Software
| Business Intelligence Software | |
|---|---|
| Metabase | Business intelligence and analytics software |
| Grafana | Platform for monitoring and observability |
| Superset | Data visualization and data exploration platform |
| Pentaho | Enterprise reporting, analysis, dashboard, data mining, workflow |
| Redash | Explore, query, visualize, and share data |
| Knowage | (formerly SpagoBI) Flexible business intelligence suite |
| ReportServer | Modern and versatile business intelligence platform |
| KNIME | Konstanz Information Miner |
| JasperReports | A widely used reporting engine |
| Rill | Operational BI tool |
| BIRT Project | Eclipse-based reporting system |
| Gephi | Visualization and exploration software for all kinds of graphs and networks |
| Lightdash | Looker alternative |
| evidence | Code-based alternative to drag-and-drop business intelligence tools |
| Briefer | Collaborative data workspace for teams |
| Shaper | SQL-first analytics and dashboard platform |
| RapidMiner | Data analysis, knowledge discovery, data mining, predictive analytics |
Read our verdict in the software roundup.
 Explore our carefully curated directory of recommended free and open source software, covering every major software category.The directory forms part of our extensive collection of articles for Linux enthusiasts. It includes hundreds of detailed reviews, together with free and open source alternatives to proprietary software from companies such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. LinuxLinks also covers interesting projects worth exploring, Linux-compatible hardware, free programming books and tutorials, and much more. Know a useful free and open source Linux application that we haven’t covered? Tell us about it using our submission form. |
Please read our Comment Policy before commenting.