Fundamentals 5 min read

Apache Superset – Overview and Supported Databases

Apache Superset is a modern, enterprise‑ready open‑source business intelligence web application that offers rich data visualizations, an easy‑to‑use interface, dashboard sharing, robust security, a semantic layer, and integration with a wide range of relational and analytical databases.

Architects Research Society
Architects Research Society
Architects Research Society
Apache Superset – Overview and Supported Databases

Apache Superset (currently incubating) is a modern, enterprise‑ready open‑source business intelligence web application.

Disclaimer: Superset is an Apache Software Foundation (ASF) incubating project sponsored by the Apache Incubator. All newly accepted projects remain in incubation until their infrastructure, communication, and decision‑making processes are stable and align with other successful ASF projects. Incubation does not necessarily reflect code completeness or stability, but indicates the project has not yet been fully recognized by the ASF.

Feature Overview

Rich set of data visualizations

Intuitive interface for exploring and visualizing data

Creation and sharing of dashboards

Enterprise‑grade authentication integration with major providers (databases, OpenID, LDAP, OAuth, and REMOTE_USER via Flask AppBuilder)

Scalable, fine‑grained security/permissions model allowing complex rules on who can access specific features and datasets

Simple semantic layer enabling control over which fields appear in dropdowns and which aggregate or functional metrics are available to users

Integration with most SQL‑speaking RDBMS via SQLAlchemy

Deep integration with Druid.io

Supported Databases

Superset currently supports the following RDBMS and analytical engines:

Amazon Athena

Amazon Redshift

Apache Drill

Apache Druid

Apache Hive

Apache Impala

Apache Kylin

Apache Pinot

Apache Spark SQL

BigQuery

ClickHouse

CockroachDB

Dremio

Elasticsearch

Exasol

Google Sheets

Greenplum

IBM Db2

MySQL

Oracle

PostgreSQL

Presto

Snowflake

SQLite

SQL Server

Teradata

Vertica

Hana

Additional database engines with appropriate DB‑API drivers and SQLAlchemy dialects are also supported.

Screenshots

business intelligenceopen sourceData VisualizationSQLAlchemyDatabase IntegrationApache Superset
Architects Research Society
Written by

Architects Research Society

A daily treasure trove for architects, expanding your view and depth. We share enterprise, business, application, data, technology, and security architecture, discuss frameworks, planning, governance, standards, and implementation, and explore emerging styles such as microservices, event‑driven, micro‑frontend, big data, data warehousing, IoT, and AI architecture.

0 followers
Reader feedback

How this landed with the community

login Sign in to like

Rate this article

Was this worth your time?

Sign in to rate
Discussion

0 Comments

Thoughtful readers leave field notes, pushback, and hard-won operational detail here.