Apache Superset Cheat Sheet

Updated 2026-05-26

Next Topic: Augmented Analytics Cheat Sheet

🧠Study flashcards on this topic149 cards · spaced repetition→

Apache Superset is an open-source data exploration and visualization platform designed for modern business intelligence workloads. Born at Airbnb and now an Apache Software Foundation top-level project, Superset connects to 80+ SQL-speaking databases, provides a semantic layer for defining metrics once and reusing them everywhere, and ships with 40+ visualizations from simple bar charts to geospatial deck.gl maps. Version 6.x brought a complete Ant Design v5 token-based theming overhaul with native dark mode, a new AG Grid-powered table handling 500K rows, user group-based access control, and a plugin-based Extensions framework inspired by VS Code — all still running on a lightweight Python/Flask backend that scales horizontally. The key insight to remember: Superset is a thin visualization layer that delegates all heavy computation to your data warehouse, so performance depends primarily on optimizing source queries and leveraging caching strategies like Redis.

What This Cheat Sheet Covers

This topic spans 23 focused tables and 273 indexed concepts, 149 flashcards. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Installation MethodsTable 2: Database Connection DriversTable 3: Core Configuration SettingsTable 4: Datasets and Semantic LayerTable 5: SQL Lab FeaturesTable 6: Popular Chart TypesTable 7: Dashboard Creation and LayoutTable 8: Filters and InteractivityTable 9: Caching ConfigurationTable 10: Security and Authentication MethodsTable 11: Row-Level Security (RLS)Table 12: User Roles and PermissionsTable 13: Alerts and ReportsTable 14: Embedding DashboardsTable 15: API and Programmatic AccessTable 16: Feature Flags ReferenceTable 17: Query Optimization StrategiesTable 18: Deployment ConfigurationsTable 19: Jinja Templating in SQLTable 20: Custom Styling and ThemesTable 21: Annotation LayersTable 22: Extensions FrameworkTable 23: Troubleshooting and Common Issues

Quick IndexSubscribe to unlock

A jump-to index of every table row in this cheat sheet.

Mind MapSubscribe to unlock

An interactive map of every table and concept in this topic.

Table 1: Installation Methods

The current stable release is 6.1.0 (May 2026). Every method below results in the same core application; the choice is driven by your operational context — Docker Compose for local exploration, Helm for production Kubernetes clusters, pip for single-server setups, and the managed Preset service to avoid all infrastructure work entirely.

Method	Example	Description
Docker Compose (recommended)	`git clone https://github.com/apache/superset` `cd superset` `docker compose up`	• Official quickstart approach • brings up all services (Superset, PostgreSQL metadata DB, Redis cache, Celery workers) with minimal configuration • ideal for local development and testing.
Kubernetes with Helm	`helm repo add superset https://apache.github.io/superset` `helm install superset superset/superset`	• Best-practice method for production deployments • supports horizontal scaling, high availability, rolling updates, and advanced infrastructure management • most robust option.
pip install (PyPI)	`pip install apache-superset` `superset db upgrade` `superset init` `superset run -p 8088`	• Direct Python package installation • suitable for single-server development or simple deployments • requires manual setup of metadata DB, Redis, and Celery • Python 3.11+ required (3.9 deprecated in 5.0).
Installing from source	`git clone https://github.com/apache/superset` `cd superset` `make install`	• Used for contributing to Superset or building custom features • gives full control over the codebase • requires Node.js v20+ for frontend build.
Preset Cloud (managed)	Sign up at preset.io → create workspace → connect databases	• Fully managed SaaS version of Superset • zero infrastructure overhead • includes enterprise security, collaboration, and premium support • ideal for teams wanting Superset without operations burden.
RHEL / Rocky Linux	Install Python 3.11, pip → `pip install apache-superset` → configure systemd service	• Supported on RHEL 9 / Rocky Linux 9 • requires Python 3.11 from AppStream • use pip virtual environment for isolation.
Windows installation	Install Docker Desktop for Windows → use Docker Compose method	• Superset is not officially supported for native Windows • Docker Desktop is the recommended workaround • alternatively use WSL2 with Linux installation steps.

Table 2: Database Connection Drivers

Superset supports 80+ databases with varying feature levels. The connection is made by installing the appropriate Python DB-API driver in the Superset environment — either into the Docker image via requirements-local.txt or via pip install for bare-metal setups. SSH tunneling is available for many databases via the SSH_TUNNELING feature flag.

Database	Example	Description
PostgreSQL	`pip install psycopg2-binary` URI: `postgresql://user:pass@host:5432/db`	• Most popular metadata database for Superset itself • driver psycopg2 required • fully supported for both metadata storage and data sources.

The rest of this section is part of the full cheat sheet

Table 3: Core Configuration Settings

All configuration lives in superset_config.py, pointed to by the SUPERSET_CONFIG_PATH environment variable. Parameters override defaults from superset/config.py — copy only the keys you intend to change. The most critical settings are SECRET_KEY and SQLALCHEMY_DATABASE_URI; every other setting has a safe default for development but requires review for production.

Setting	Example	Description
superset_config.py location	`export SUPERSET_CONFIG_PATH=/app/superset_config.py`	• Primary configuration file • must set SUPERSET_CONFIG_PATH environment variable pointing to file location • overrides defaults in config.py.

The rest of this section is part of the full cheat sheet

Table 4: Datasets and Semantic Layer

Datasets are Superset's central abstraction between raw database tables and the chart builder. Defining metrics and calculated columns at the dataset level — rather than inside each chart — creates a reusable semantic layer: change a metric formula once and all charts using it update automatically. Dataset Folders and the Tagging System (both behind feature flags in 6.x) improve discoverability for large datasets.

Concept	Example	Description
Physical Dataset	Select table sales_transactions from database → Add Dataset	• Represents a direct database table or view • simplest dataset type; inherits all columns from source table • used for straightforward reporting.

The rest of this section is part of the full cheat sheet

Table 1: Installation Methods

Method	Example	Description
Docker Compose (recommended)	`git clone https://github.com/apache/superset` `cd superset` `docker compose up`	• Official quickstart approach • brings up all services (Superset, PostgreSQL metadata DB, Redis cache, Celery workers) with minimal configuration • ideal for local development and testing.
Kubernetes with Helm	`helm repo add superset https://apache.github.io/superset` `helm install superset superset/superset`	• Best-practice method for production deployments • supports horizontal scaling, high availability, rolling updates, and advanced infrastructure management • most robust option.
pip install (PyPI)	`pip install apache-superset` `superset db upgrade` `superset init` `superset run -p 8088`	• Direct Python package installation • suitable for single-server development or simple deployments • requires manual setup of metadata DB, Redis, and Celery • Python 3.11+ required (3.9 deprecated in 5.0).
Installing from source	`git clone https://github.com/apache/superset` `cd superset` `make install`	• Used for contributing to Superset or building custom features • gives full control over the codebase • requires Node.js v20+ for frontend build.
Preset Cloud (managed)	Sign up at preset.io → create workspace → connect databases	• Fully managed SaaS version of Superset • zero infrastructure overhead • includes enterprise security, collaboration, and premium support • ideal for teams wanting Superset without operations burden.
RHEL / Rocky Linux	Install Python 3.11, pip → `pip install apache-superset` → configure systemd service	• Supported on RHEL 9 / Rocky Linux 9 • requires Python 3.11 from AppStream • use pip virtual environment for isolation.
Windows installation	Install Docker Desktop for Windows → use Docker Compose method	• Superset is not officially supported for native Windows • Docker Desktop is the recommended workaround • alternatively use WSL2 with Linux installation steps.

Table 2: Database Connection Drivers

Database	Example	Description
PostgreSQL	`pip install psycopg2-binary` URI: `postgresql://user:pass@host:5432/db`	• Most popular metadata database for Superset itself • driver psycopg2 required • fully supported for both metadata storage and data sources.

Table 3: Core Configuration Settings

Setting	Example	Description
superset_config.py location	`export SUPERSET_CONFIG_PATH=/app/superset_config.py`	• Primary configuration file • must set SUPERSET_CONFIG_PATH environment variable pointing to file location • overrides defaults in config.py.

Table 4: Datasets and Semantic Layer

Concept	Example	Description
Physical Dataset	Select table sales_transactions from database → Add Dataset	• Represents a direct database table or view • simplest dataset type; inherits all columns from source table • used for straightforward reporting.