Rill

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Overview

Rill is an operational business intelligence tool for building fast, interactive dashboards directly from your data. It pairs a data modelling workflow with an embedded DuckDB engine, so you define sources and metrics as simple configuration files and explore the results in a live dashboard with sub-second queries, no separate data warehouse or BI server to stand up. This image delivers Rill fully installed and configured as a system service, with a ready-made sample analytics project, so an interactive dashboard is live within minutes of launch.

Application Stack

The single Rill binary installed under /usr/local/bin and run by a dedicated unprivileged service account. An embedded DuckDB engine that queries your data in process, with no external database to operate. A ready-made sample project, a CSV source, a metrics view and an Explore dashboard, so the console shows real charts on first launch. The sample project, DuckDB storage and Rill runtime home stored on a dedicated data volume so dashboard state is independently resizable and survives instance replacement. A systemd service that starts Rill on boot and restarts it on failure. An nginx reverse proxy that publishes the Rill web console on port 80.

Build Dashboards From Data

Rill turns data files and sources into operational dashboards through a code-first modelling workflow. Define a source, shape it with SQL models, describe a metrics view with dimensions and measures, and Rill renders an interactive Explore dashboard you can slice by any dimension and pivot across time. The embedded DuckDB engine keeps queries fast and local, so exploration stays responsive without a separate analytics cluster.

Secure First Boot

Rill's local interface ships without authentication, so this image binds the Rill listener to loopback and fronts it with an nginx reverse proxy that enforces HTTP Basic authentication, with a defence-in-depth firewall rule that drops any off-box traffic to the application port. On the first boot of your instance a one shot service generates a fresh admin password, unique to that instance, writes it into the nginx credential store and records it in a root only file. No shared or default credentials ship in the image.

Ready To Use

The Rill web console is served on port 80 through nginx. Sign in with the generated administrator credentials to explore the sample dashboard, edit the metrics model, or point Rill at your own data.

cloudimg Support

24/7 technical support by email and chat. Help with deployment, connecting your own data sources, authoring metrics views and dashboards, authentication, TLS and reverse-proxy configuration, and storage sizing.

Use Cases

Operational dashboards over your business data. Interactive metric exploration and slicing. Fast in process analytics on files and object storage. Self-service BI for analysts and product teams. A code-first modelling workflow for versioned dashboards.

Rill is licensed under the Apache License 2.0. All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.