What is Rill?

Rill Developer makes it effortless to transform your datasets with SQL and create powerful, opinionated dashboards. Rill's principles:

• feels good to use – powered by Sveltekit & DuckDB = conversation-fast, not wait-ten-seconds-for-result-set fast
• works with your local and remote datasets – imports and exports Parquet and CSV (s3, gcs, https, local)
• no more data analysis "side-quests" – helps you build intuition about your dataset through automatic profiling
• no "run query" button required – responds to each keystroke by re-profiling the resulting dataset
• radically simple dashboards – thoughtful, opinionated defaults to help you quickly derive insights from your data
• dashboards as code – each step from data to dashboard has versioning, git sharing, and easy project rehydration

Install

You can get started in less than 2 minutes with Rill's installation script (Mac and Linux):

curl -s https://cdn.rilldata.com/install.sh | bash

See Rill's documentation for more information about using Rill.

Creating a project

In Rill, all data sources, data models, and dashboard definitions are saved as Rill project files on disk. You can edit these directly or check them into Git to share your project with others.

For this tutorial, let's checkout an example project from the git repository:

git clone https://github.com/rilldata/rill-developer-example.git
cd rill-developer-example

Alternatively, you can create a new, empty Rill project:

rill init --project my-project
cd my-project

Starting the application

Now it's time to start the application:

rill start

When you run rill start, it parses your project and ingests any missing data sources into a local DuckDB database. After your project has been re-hydrated, it starts the Rill web app on http://localhost:9009.

Editing and sharing a project

You can use the Rill web app to add or edit data sources, data models, and dashboards. All changes you make in the UI and CLI are versionable because they are reflected as Rill project files stored on disk. You can share your Rill project files with others by pushing to a shared repository, and they'll be able to completely recreate your project just by running rill start.

Have fun exploring Rill!

Rill wants to hear from you

You can file an issue directly in Rill's repository or reach Rill in their discord channel. Please abide by the rill community policy.