A modern, enterprise-ready business intelligence web application

Spotrix

A modern, enterprise-ready business intelligence web application.

Features

Embedded and server modes & disk-based or in-memory databases: Interactive data analysis, e.g. Joining & aggregate multiple large tables, so simple and fast.
Powerful yet easy to use: Quickly and easily integrate and explore your data, using either our simple no-code viz builder or state-of-the-art SQL IDE.
Integrates with modern databases: Spotrix can connect to any SQL based datasource through SQLAlchemy, including modern cloud native databases and engines at petabyte scale.
Modern architecture: Spotrix is lightweight and highly scalable, leveraging the power of your existing data infrastructure without requiring yet another ingestion layer.
Rich visualizations and dashboards: Spotrix ships with a wide array of beautiful visualizations. Our visualization plug-in architecture makes it easy to build custom visualizations that drop directly into Spotrix.

Quickstart

Firstly, Install & run your spotrix server with python3 env:

pip install spotrix
spotrix init
spotrix run

Then, open your browser with http://localhost:5000, enjoying your explore.

Why Spotrix?

Spotrix provides:

An intuitive interface for visualizing datasets and crafting interactive dashboards
A wide array of beautiful visualizations to showcase your data
Code-free visualization builder to extract and present datasets
A world-class SQL IDE for preparing data for visualization, including a rich metadata browser
A lightweight semantic layer which empowers data analysts to quickly define custom dimensions and metrics
Out-of-the-box support for most SQL-speaking databases
Seamless, in-memory asynchronous caching and queries
An extensible security model that allows configuration of very intricate rules on who can access which product features and datasets.
Integration with major authentication backends (database, OpenID, LDAP, OAuth, REMOTE_USER, etc)
The ability to add custom visualization plugins
An API for programmatic customization
A cloud-native architecture designed from the ground up for scale

Spotrix is cloud-native and designed to be highly available. It was designed to scale out to large, distributed environment and works very well inside containers. While you can easily test drive Spotrix on a modest setup or simple on your laptop, there's virtually no limit around scaling out the platform.

Spotrix is also cloud-naive in the sense that it is flexible and lets you choose the:

Web server (Gunicorn, Nginx)
Metadata database engine (MySQL, Postgres, MariaDB, Sqlite, Guinsoo 🚀, etc)
Message queue (Redis, RabbitMQ, etc)
Results backend (S3, MinIO, AnnaStore 🌈, etc)

Spotrix also works well with services like LeonaLog, NewRelic, StatsD and DataDog, and has the ability to run analytic workloads against most popular database technologies.

Supported Databases

Spotrix can query data from any SQL-speaking datastore or data engine (e.g. Presto or Athena) that has a Python DB-API driver and a SQLAlchemy dialect.

Here are some of the major database solutions that are supported: