Apache Superset

Apache Superset connects to Elasticsearch via the Arrow Flight SQL protocol, enabling full SQL dashboards and data exploration.

Prerequisites

• A running Arrow Flight SQL server (see Arrow Flight SQL guide)
• Apache Superset installed

Quick Start with Docker

The demo includes a pre-configured Superset with sample e-commerce dashboards:

docker compose --profile superset-flight up

Then open Superset at http://localhost:8088.

Manual Setup

1. Install the Flight SQL driver

In your Superset environment:

pip install adbc-driver-flightsql

2. Add Database Connection

1. Go to Settings > Database Connections > + Database
2. Select Other as the database type
3. Enter the SQLAlchemy URI:

adbc_flight_sql://localhost:32010

3. Create Charts and Dashboards

Once connected, you can use the full SoftClient4ES SQL syntax directly in Superset:

SELECT
  customer_name,
  SUM(total_price) AS revenue,
  COUNT(*) AS orders
FROM ecommerce
GROUP BY customer_name
ORDER BY revenue DESC;

Supported Features

Feature	Status
SELECT queries	Tested
Aggregations (GROUP BY)	Tested
Window functions	Tested
DDL (CREATE/ALTER/DROP)	Tested
DML (INSERT/UPDATE/DELETE)	Tested
SHOW/DESCRIBE	Tested
Chart creation	Tested
Dashboard creation	Tested

License

Superset integration uses the Arrow Flight SQL server, licensed under the Elastic License 2.0.