# Apache 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

<figure><img src="https://3952707095-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUD8kiAsnN8MKP7nzsJRQ%2Fuploads%2Fgit-blob-2cfb9c267487574052d6a3226c54284c324efcea%2Fimage.png?alt=media" alt=""><figcaption><p>Web superset configuration</p></figcaption></figure>

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

<figure><img src="https://3952707095-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUD8kiAsnN8MKP7nzsJRQ%2Fuploads%2Fgit-blob-45efb35fe71a13487aa45a7e3c1d1ec62bdcc472%2Fimage.png?alt=media" alt=""><figcaption><p>Superset Worker Configuration</p></figcaption></figure>

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)

<figure><img src="https://3952707095-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUD8kiAsnN8MKP7nzsJRQ%2Fuploads%2Fgit-blob-6dfa9ef3b65fd6c55fa534d74c1852c6cc6fff28%2Fimage.png?alt=media" alt=""><figcaption></figcaption></figure>

Step4 - Admin user configuration

<figure><img src="https://3952707095-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUD8kiAsnN8MKP7nzsJRQ%2Fuploads%2Fgit-blob-1de58c5e72d5c2b37429c67c2910f1247c365d71%2Fimage.png?alt=media" alt=""><figcaption><p>Admin configuration</p></figcaption></figure>

***

### Usage

After installation, you can utilize Superset for data visualization 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, click the **Open App** button at the top of the page to launch the application in a dedicated browser window.

Connect the data sources, build charts, and dashboards.

<figure><img src="https://3952707095-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUD8kiAsnN8MKP7nzsJRQ%2Fuploads%2Fgit-blob-403e99a768f388c009d5fce03f0161ca43dd7aa7%2Fimage.png?alt=media" alt=""><figcaption></figcaption></figure>

### References:

* [Apache Superset Documentation](https://superset.apache.org/docs/intro)
* Apache Superset Cli installation
* [Apache Superset source code](https://github.com/apache/superset)
* [Managing Apps](https://docs.apolo.us/index/apolo-console/apps/installable-apps/managing-apps)
* [App Cli documentation](https://docs.apolo.us/index/apolo-concepts-cli/apps)