Overview

Maxime Beauchemin created Superset at Airbnb in 2015 to explore large datasets on Presto without desktop software. Joining the Apache Software Foundation, the project became a web-based analytics platform running inside private infrastructure. For operations leads, that heritage means queries execute directly against existing data stores rather than through vendor SaaS clouds.

Why Apache Superset instead of Tableau

Tableau relies on desktop authoring paired with Tableau Server or Cloud, requiring local installations, proprietary Hyper extracts, and escalating per-seat fees as viewer counts grow. Apache Superset replaces this with a browser-first architecture where charting, dashboards, and SQL Lab operate on a unified web service. Because Superset connects directly to datastores via SQLAlchemy dialects—from PostgreSQL to Snowflake and Trino—queries execute in-place, keeping data inside your infrastructure without exporting records to external vendor clouds.

The operational tradeoff centers on infrastructure ownership. Tableau manages updates, backups, and client compatibility behind a commercial subscription. Self-hosting Superset requires running Python application containers, Redis caching, Celery workers for scheduled reports, and a PostgreSQL metadata store. An operations team eliminates recurring license costs and controls deployments, but inherits packaging database drivers, running migrations, and sizing worker capacity for query spikes.

What it does well

SQL Lab workspace: provides multi-tab querying, schema browsing, and Jinja templating, letting analysts prototype queries and build charts without desktop software.
Embedded analytics: allows teams to embed interactive dashboards into web applications using signed guest tokens and row-level security without per-viewer fees.
In-place querying: pushes analytical workloads directly to SQL databases via SQLAlchemy dialects, eliminating proprietary data extracts.
Access control: provides role-based permissions across datasets, dashboards, and databases, integrating with OAuth2, LDAP, and OpenID Connect.
Automated delivery: sends dashboard snapshots and CSV exports to Slack or email on a cron schedule using Celery workers.
Query caching: integrates with Redis to cache query results and charts, protecting databases from repetitive analytical load.

services: superset: image: apache/superset:6.1.0-dev user: "root" command: ["/app/docker/entrypoints/run-server.sh"] ports: - "8088:8088" environment: SUPERSET_SECRET_KEY: ${SUPERSET_SECRET_KEY} SUPERSET__SQLALCHEMY_DATABASE_URI: postgresql+psycopg2://superset:${POSTGRES_PASSWORD}@db:5432/superset POSTGRES_DB: superset POSTGRES_USER: superset POSTGRES_PASSWORD: ${POSTGRES_PASSWORD} POSTGRES_HOST: db POSTGRES_PORT: 5432 DATABASE_DB: superset DATABASE_HOST: db DATABASE_PORT: 5432 DATABASE_USER: superset DATABASE_PASSWORD: ${POSTGRES_PASSWORD} DATABASE_DIALECT: postgresql SUPERSET_LOAD_EXAMPLES: "no" DEV_MODE: "false" FLASK_DEBUG: "false" SUPERSET_ENV: "production" depends_on: db: condition: service_healthy superset-init: condition: service_completed_successfully restart: unless-stopped volumes: - superset_home:/app/superset_home healthcheck: test: ["CMD-SHELL", "curl -f http://localhost:8088/health || exit 1"] interval: 10s timeout: 5s retries: 10 superset-init: image: apache/superset:6.1.0-dev user: "root" command: - /bin/sh - -c - | set -e superset db upgrade superset fab create-admin --username admin --firstname Superset --lastname Admin --email [email protected] --password "$${ADMIN_PASSWORD}" superset init environment: SUPERSET_SECRET_KEY: ${SUPERSET_SECRET_KEY} SUPERSET__SQLALCHEMY_DATABASE_URI: postgresql+psycopg2://superset:${POSTGRES_PASSWORD}@db:5432/superset POSTGRES_DB: superset POSTGRES_USER: superset POSTGRES_PASSWORD: ${POSTGRES_PASSWORD} POSTGRES_HOST: db POSTGRES_PORT: 5432 DATABASE_DB: superset DATABASE_HOST: db DATABASE_PORT: 5432 DATABASE_USER: superset DATABASE_PASSWORD: ${POSTGRES_PASSWORD} DATABASE_DIALECT: postgresql ADMIN_PASSWORD: ${ADMIN_PASSWORD} SUPERSET_LOAD_EXAMPLES: "no" DEV_MODE: "false" FLASK_DEBUG: "false" SUPERSET_ENV: "production" depends_on: db: condition: service_healthy restart: "no" volumes: - superset_home:/app/superset_home db: image: postgres:17-alpine environment: POSTGRES_DB: superset POSTGRES_USER: superset POSTGRES_PASSWORD: ${POSTGRES_PASSWORD} volumes: - db_home:/var/lib/postgresql/data restart: unless-stopped healthcheck: test: ["CMD-SHELL", "pg_isready -U superset -d superset"] interval: 5s timeout: 5s retries: 5 volumes: superset_home: db_home:

superset-1 | 2026-11-01T23:20:59.732170971Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.732171763Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.732172513Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.732173346Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.732177929Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.732814013Z 2026-11-01 23:20:59,732:WARNING:superset.views.error_handling:HTTPException superset-1 | 2026-11-01T23:20:59.732816388Z Traceback (most recent call last): superset-1 | 2026-11-01T23:20:59.732817263Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset-1 | 2026-11-01T23:20:59.732818179Z rv = self.dispatch_request() superset-1 | 2026-11-01T23:20:59.732818929Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1458, in dispatch_request superset-1 | 2026-11-01T23:20:59.732819804Z self.raise_routing_exception(req) superset-1 | 2026-11-01T23:20:59.732820554Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1440, in raise_routing_exception superset-1 | 2026-11-01T23:20:59.732821429Z raise request.routing_exception # type: ignore superset-1 | 2026-11-01T23:20:59.732822304Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.732823138Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.732823929Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.732824763Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.732825513Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.732831471Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /yii/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (Macintosh, Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.1 Safari/605.1.15" superset-1 | 2026-11-01T23:20:59.733488804Z 2026-11-01 23:20:59,733:WARNING:superset.views.error_handling:HTTPException superset-1 | 2026-11-01T23:20:59.733491429Z Traceback (most recent call last): superset-1 | 2026-11-01T23:20:59.733492346Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset-1 | 2026-11-01T23:20:59.733493304Z rv = self.dispatch_request() superset-1 | 2026-11-01T23:20:59.733494013Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1458, in dispatch_request superset-1 | 2026-11-01T23:20:59.733494846Z self.raise_routing_exception(req) superset-1 | 2026-11-01T23:20:59.733495554Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1440, in raise_routing_exception superset-1 | 2026-11-01T23:20:59.733496388Z raise request.routing_exception # type: ignore superset-1 | 2026-11-01T23:20:59.733497138Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.733497929Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.733498721Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.733499554Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.733502721Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.733820554Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /laravel/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.2 Safari/605.1.15" superset-1 | 2026-11-01T23:20:59.733823471Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /laravel/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.2.1 Safari/605.1.15" superset-1 | 2026-11-01T23:20:59.734255554Z 2026-11-01 23:20:59,734:WARNING:superset.views.error_handling:HTTPException superset-1 | 2026-11-01T23:20:59.734258013Z Traceback (most recent call last): superset-1 | 2026-11-01T23:20:59.734258846Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset-1 | 2026-11-01T23:20:59.734259721Z rv = self.dispatch_request() superset-1 | 2026-11-01T23:20:59.734260513Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1458, in dispatch_request superset-1 | 2026-11-01T23:20:59.734261346Z self.raise_routing_exception(req) superset-1 | 2026-11-01T23:20:59.734262096Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1440, in raise_routing_exception superset-1 | 2026-11-01T23:20:59.734262929Z raise request.routing_exception # type: ignore superset-1 | 2026-11-01T23:20:59.734263679Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.734264471Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.734265221Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.734266054Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.734266804Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.734603304Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /laravel52/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.93 Safari/537.36" superset-1 | 2026-11-01T23:20:59.735526846Z 2026-11-01 23:20:59,735:WARNING:superset.views.error_handling:HTTPException superset-1 | 2026-11-01T23:20:59.735530846Z Traceback (most recent call last): superset-1 | 2026-11-01T23:20:59.735531679Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset-1 | 2026-11-01T23:20:59.735532554Z rv = self.dispatch_request() superset-1 | 2026-11-01T23:20:59.735533304Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1458, in dispatch_request superset-1 | 2026-11-01T23:20:59.735534138Z self.raise_routing_exception(req) superset-1 | 2026-11-01T23:20:59.735534929Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1440, in raise_routing_exception superset-1 | 2026-11-01T23:20:59.735538013Z raise request.routing_exception # type: ignore superset-1 | 2026-11-01T23:20:59.735538804Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.735539638Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.735540388Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.735541221Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.735541929Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.736333888Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /lib/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (Ubuntu; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36" superset-1 | 2026-11-01T23:20:59.736338971Z 2026-11-01 23:20:59,735:WARNING:superset.views.error_handling:HTTPException superset-1 | 2026-11-01T23:20:59.736340138Z Traceback (most recent call last): superset-1 | 2026-11-01T23:20:59.736340929Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset-1 | 2026-11-01T23:20:59.736341929Z rv = self.dispatch_request() superset-1 | 2026-11-01T23:20:59.736342638Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1458, in dispatch_request superset-1 | 2026-11-01T23:20:59.736343513Z self.raise_routing_exception(req) superset-1 | 2026-11-01T23:20:59.736344263Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1440, in raise_routing_exception superset-1 | 2026-11-01T23:20:59.736345096Z raise request.routing_exception # type: ignore superset-1 | 2026-11-01T23:20:59.736345888Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.736346721Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.736347471Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.736348304Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.736349054Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.737227179Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /zend/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.11 Safari/605.1.15" superset-1 | 2026-11-01T23:20:59.737232846Z 2026-11-01 23:20:59,736:WARNING:superset.views.error_handling:HTTPException superset-1 | 2026-11-01T23:20:59.737233846Z Traceback (most recent call last): superset-1 | 2026-11-01T23:20:59.737234804Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset-1 | 2026-11-01T23:20:59.737235721Z rv = self.dispatch_request() superset-1 | 2026-11-01T23:20:59.737236471Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1458, in dispatch_request superset-1 | 2026-11-01T23:20:59.737239929Z self.raise_routing_exception(req) superset-1 | 2026-11-01T23:20:59.737240721Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1440, in raise_routing_exception superset-1 | 2026-11-01T23:20:59.737241554Z raise request.routing_exception # type: ignore superset-1 | 2026-11-01T23:20:59.737242304Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.737243263Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.737244013Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.737244846Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.737245554Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.737665388Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /laravel52/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36" superset-1 | 2026-11-01T23:20:59.738163429Z 2026-11-01 23:20:59,738:WARNING:superset.views.error_handling:HTTPException superset-1 | 2026-11-01T23:20:59.738165888Z Traceback (most recent call last): superset-1 | 2026-11-01T23:20:59.738166763Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset-1 | 2026-11-01T23:20:59.738167596Z rv = self.dispatch_request() superset-1 | 2026-11-01T23:20:59.738168388Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1458, in dispatch_request superset-1 | 2026-11-01T23:20:59.738169221Z self.raise_routing_exception(req) superset-1 | 2026-11-01T23:20:59.738169929Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1440, in raise_routing_exception superset-1 | 2026-11-01T23:20:59.738170763Z raise request.routing_exception # type: ignore superset-1 | 2026-11-01T23:20:59.738171513Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.738172304Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.738173054Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.738173846Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.738174596Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.738528888Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /lib/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (Knoppix; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36" superset-1 | 2026-11-01T23:20:59.739212429Z 2026-11-01 23:20:59,739:WARNING:superset.views.error_handling:HTTPException superset-1 | 2026-11-01T23:20:59.739216054Z Traceback (most recent call last): superset-1 | 2026-11-01T23:20:59.739216888Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request superset-1 | 2026-11-01T23:20:59.739220013Z rv = self.dispatch_request() superset-1 | 2026-11-01T23:20:59.739220846Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1458, in dispatch_request superset-1 | 2026-11-01T23:20:59.739221679Z self.raise_routing_exception(req) superset-1 | 2026-11-01T23:20:59.739222471Z File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1440, in raise_routing_exception superset-1 | 2026-11-01T23:20:59.739223346Z raise request.routing_exception # type: ignore superset-1 | 2026-11-01T23:20:59.739224096Z File "/app/.venv/lib/python3.10/site-packages/flask/ctx.py", line 353, in match_request superset-1 | 2026-11-01T23:20:59.739224929Z result = self.url_adapter.match(return_rule=True) # type: ignore superset-1 | 2026-11-01T23:20:59.739225679Z File "/app/.venv/lib/python3.10/site-packages/werkzeug/routing/map.py", line 629, in match superset-1 | 2026-11-01T23:20:59.739226471Z raise NotFound() from None superset-1 | 2026-11-01T23:20:59.739227221Z werkzeug.exceptions.NotFound: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. superset-1 | 2026-11-01T23:20:59.739556971Z 192.168.65.197 - - [01/Nov/2026:23:20:59 +0000] "GET /zend/vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1" 404 334 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.3" superset-1 | 2026-11-01T23:21:04.879875875Z 127.0.0.1 - - [01/Nov/2026:23:21:04 +0000] "GET /health HTTP/1.1" 200 2 "-" "curl/7.88.1" superset-1 | 2026-11-01T23:21:14.930371546Z 127.0.0.1 - - [01/Nov/2026:23:21:14 +0000] "GET /health HTTP/1.1" 200 2 "-" "curl/7.88.1"

Apache Superset

Overview

Why Apache Superset instead of Tableau

What it does well

Similar Open Source Tools

OpenBB

Limitations

Who should use it

FAQ

Verdict

Self-host Apache Superset with Docker

Download the compose file

Create .env with fresh secrets

Start it

First run

Project README

GitHub Repository Metrics

Supported Platforms

Maintainer? Add the badge

Metabase

drawDB