Download
Rill is an operational BI tool that turns raw datasets into fast, interactive dashboards using SQL and a code-first approach. It helps data teams move from data lake to insight quickly, without the complexity of traditional BI systems. With an embedded in-memory database powered by DuckDB or ClickHouse, queries run in milliseconds, enabling real-time exploration and analysis. Rill supports local and remote data sources such as CSV, Parquet, S3, and GCS, making it flexible across environments. Its BI-as-code model combines SQL, YAML configuration, Git version control, and CLI tools, allowing teams to build, manage, and deploy analytics workflows efficiently. Automatic data profiling and responsive query updates help users understand datasets instantly. Interactive dashboards come with opinionated defaults, so teams can focus on insights instead of setup, while metrics layers standardize business logic for consistent reporting across dashboards, APIs, and AI systems.
Features
- SQL-based BI-as-code workflow with YAML configuration and Git integration
- Embedded in-memory database using DuckDB or ClickHouse for fast queries
- Real-time data exploration with instant query re-profiling
- Automatic data profiling to quickly understand datasets
- Support for multiple data sources including CSV, Parquet, S3, and GCS
- Interactive dashboards with built-in metrics layer for consistent analytics
Project Samples
