Apache Superset

Apache Superset is a data exploration and visualization platform that can replace or augment the proprietary business intelligence tools a team is paying for. Analysts build charts and dashboards, administrators keep the deployment safe, and developers extend it through an API.

It queries any SQL-speaking datastore that has a Python DB-API driver and a SQLAlchemy dialect, which covers conventional databases as well as engines like Presto, Trino and Athena. The architecture was designed for scale from the start rather than adapted to it.

What arrives out of the box spans the whole path from query to dashboard.

• No-code interface: build charts quickly without writing SQL.
• SQL editor: a web-based editor for the queries that need real control.
• Semantic layer: a lightweight way to define custom dimensions and metrics once.
• Visualizations: a large gallery running from simple bar charts to geospatial views.
• Caching layer: configurable and light, to ease load on the underlying database.
• Security and API: extensible roles and authentication options, plus an API for programmatic customization.

A quickstart gets it running with Docker Compose in a couple of minutes, and production deployments are covered by an official Docker image and a Helm chart. Documentation is split by audience, so analysts, operators and contributors each have their own guide, and the project is governed by the Apache Software Foundation.