Home

Awesome

Turnilo

npm version build status Join our Slack chat

Turnilo is a business intelligence, data exploration and visualization web application for Apache Druid. Turnilo is a fork of Pivot which is currently available under commercial licence only. This repository was forked from the stalled repository Swiv with the latest version of Pivot under Apache license.

Motivation

Druid is heavily used as business intelligence platform at Allegro. In order to gain wide adoption of non-technical users, Druid requires simple yet powerful user interface. In Allegro we have decided that we are going to continue Pivot development as an open source software, this is how Turnilo emerged.

Manifesto

Features

Turnilo UI

Try it!

You can try an online demo with example datasets (Covid-19 and Wikipedia) at https://turnilo.app.

Join us!

Feel free to ask on GitHub Discussions or join the chat on Slack.

Pre-requisites

:warning: Do not use yarn command for dependency management and project build, use npm instead. With npm builds are reproducible (thanks to package-lock.json) and even faster than with yarn.

Usage

Install Turnilo distribution using npm.

npm install -g turnilo

Start off by running Turnilo with example datasets and open http://localhost:9090/.

turnilo run-examples

Use connect-druid command to connect to the existing Druid broker. Turnilo will automatically introspect your Druid broker and figure out available datasets.

turnilo connect-druid http[s]://druid-broker-hostname[:port]

Documentation

Learn how to configure and customize Turnilo: https://allegro.github.io/turnilo/

Development

Install project dependencies.

npm install

Build the project.

npm run build

Run project

Run example datasets.

npm run start:examples

Connect to the existing Druid broker.

npm run start -- connect-druid http[s]://druid-broker-hostname[:port]

Connect to the existing Druid broker using your config file.

npm run start -- run-config path/to/config.yml

Run project in developer mode

Every change in frontend code would recompile project and reload page.

Run example datasets.

npm run start:dev:examples

Connect to the existing Druid broker.

npm run start:dev -- connect-druid http[s]://druid-broker-hostname[:port]

Connect to the existing Druid broker using your config file.

npm run start:dev -- run-config path/to/config.yml

Testing

Unit tests

Run all unit tests.

npm run test

Or run tests separately for common, client and server modules.

npm run test:common
npm run test:client
npm run test:server

End to end tests

Run all e2e tests. It will start Turnilo with example datasets in background.

npm run e2e

End to end tests development

Run server

npm start:dev:examples

Run cypress interactive tools for e2e testing

npm run e2e:dev

Debugging

Server module

In WebStorm\IntelliJ open "Run/Debug Configurations", click "Add New Configuration". Next choose "Node.JS", set "JavaScript file" to "./bin/turnilo" and "Application parameters" to "--examples".

You can find more infrmation here

Generating documentation locally

Prerequisites

Go to the docs folder and:

  1. Install bundle install or update bundle update dependencies
  2. Run bundle exec jekyll serve --livereload
  3. Open http://localhost:4000/

License

Turnilo is published under Apache License 2.0.