Superset

Apache Superset is a modern, enterprise-ready business intelligence web application for data exploration and visualization. Designed for scalability, extensibility, and ease of use, Superset supports a wide range of SQL-speaking databases and enables teams to create rich dashboards and interactive charts without writing code. Built with a lightweight architecture and a user-friendly interface, Superset is ideal for organizations seeking powerful, open-source BI tooling.

Key Features

  • Interactive Data Exploration: Drag-and-drop interface for slicing, filtering, and visualizing data across many chart types.

  • SQL Lab: A powerful SQL IDE with autocomplete, syntax highlighting, and multi-tab support for complex query workflows.

  • Rich Visualization Library: Dozens of built-in visualizations including bar, line, pie, time series, Sankey, heatmap, and geospatial charts.

  • Access Control & Security: Role-based access, row-level security filters, and integration with enterprise auth systems (e.g., OAuth, LDAP, SSO).

  • Scalable & Performant: Designed to handle large datasets with support for asynchronous queries, caching layers, and database-agnostic scalability.

  • Customizable & Extensible: Built on Flask and React; supports plugin development, custom visualization additions, and API access for automation.

Installation and Deployment on Apolo

You can deploy Apache Superset on the Apolo platform using the Apache Superset app. Apolo automates resource allocation, persistent storage, ingress, and environment variable injection, so you can focus on model configuration.

Highlights of the Apolo Installation Flow:

  1. Resource Allocation: Choose an Apolo preset (e.g. gpu-xlarge, mi210x2) that specifies CPU, memory, and GPU resources.

  2. Ingress Setup: Enable an ingress to expose vLLM’s HTTP endpoint for external access.

  3. Integration with Postgres: You can bring Postgresql instance, for example deployed on Apolo.

  4. Configuration for an admin user: Configure a Web access.


Apolo Deployment


Web Console UI

Step1 - Select the Preset you want to use for Web UI

Web superset configuration

Step2 - Select the Preset you want to use for Superset worker

Superset Worker Configuration

Step3 - Choose if you want to connect your Superset app to an existing Postgres database, and connect it with url, or you want to deploy with Superset Postgres (will be created automatically)

Step4 - Admin user configuration

Admin configuration

Usage

After installation, you can utilize Superset for image generation workflows and you can access it directly from your browser.To view and manage installed instances of the Superset app:

  1. Go to the Installed Apps tab.

  2. You will see a list of all running apps, including the Superset app you just installed. To open the detailed information & uninstall the app, click the Details button.

Once in the Details" page, scroll down to the Outputs sections. To launch the applications, find the HTTP API output with with the public domain address, copy and open it in a dedicated browser window.

Connect the data sources, build charts, and dashboards.

References:

Last updated

Was this helpful?