Superset

Interactive dashboards and SQL data exploration, powered by Apache Superset.

Overview

Superset is a full-featured business intelligence platform running inside your Calliope workspace. Connect to your databases, explore data with SQL, build charts, and publish interactive dashboards — no separate BI tool required. It’s built for data analysts and engineers who want to go from raw data to shareable insights quickly.

Key Features

• SQL Lab — Browser-based SQL editor with query history, autocomplete, and result export
• Dashboard Builder — Drag-and-drop canvas for building multi-chart dashboards
• Chart Library — 40+ chart types: bar, line, scatter, pie, maps, heatmaps, and more
• Data Exploration — Point-and-click interface for slicing and filtering datasets without writing SQL
• Database Connections — Connect to any SQL-compatible data source
• Shareable Dashboards — Share dashboards with teammates via link

Getting Started

1. From the Hub, click Superset to launch
2. Go to Data → Databases to add a database connection
3. Register a dataset from a table or a SQL query
4. Create a chart by selecting a dataset and visualization type
5. Add charts to a new dashboard

Connecting a Database

Superset supports connections via SQLAlchemy. Supported databases include:

• PostgreSQL, MySQL, MariaDB
• ClickHouse, DuckDB, Trino/Presto
• BigQuery, Snowflake, Redshift, Databricks
• SQLite (for local files)

Enter the connection string in Data → Databases → + Database.

SQL Lab

SQL Lab gives you a full query editor:

• Write SQL against any connected database
• Run multiple queries in tabs
• Save queries for reuse
• Export results to CSV
• Visualize query results directly from Lab

Building Dashboards

1. Create charts from your datasets using the Explore interface
2. Create a dashboard from the Dashboards menu
3. Add charts by editing the dashboard and dragging chart panels
4. Set filters so viewers can slice data interactively
5. Save and share the dashboard URL

When to Use Superset