# Apache Superset

> Dashboards and a SQL editor on your own databases.

- Page: https://cgt.octabyte.io/templates/superset/
- Category: Analytics
- Replaces: Tableau, Power BI and Looker
- Ease of use: Some setup. Superset starts empty, so sign in as admin with the password Cloudgate created, connect your PostgreSQL database and pick the tables to chart.
- App price: Free. To run it you need Cloudgate (hosted, or free to install yourself) and a server, which hosted Cloudgate can provide.
- License: Apache-2.0
- Good for: Teams with someone who knows SQL who want shared dashboards on their own databases
- Official website: https://superset.apache.org
- Documentation: https://superset.apache.org/docs/intro/
- Source code: https://github.com/apache/superset
- Last updated: 2026-11-20

## What is Apache Superset?

Self-hosted Apache Superset: build charts, dashboards and SQL queries on your own databases, with no per-viewer licence like Tableau or Power BI.

Apache Superset is a free, open-source business intelligence app for building charts and dashboards on the data in your own databases, and self-hosted Apache Superset can replace paid tools such as Tableau, Power BI or Looker. It reads your data live, where it is, and gives everyone on the team the same numbers without a licence for each viewer.

It has two ways in. Business users build charts from menus, while people who know SQL get SQL Lab, a full editor for writing queries and turning the results into charts. An online shop with its orders in PostgreSQL could have its analyst write one query for repeat customers, then let the owner and staff use a dashboard with filters for month and region.

Superset is an Apache Software Foundation project with no paid edition. It suits teams with someone comfortable with SQL; if nobody is, Metabase is easier to learn. Cloudgate's setup reads PostgreSQL databases; Superset can also work with MySQL, BigQuery, Snowflake and many others once their driver is added. There is no phone app; it works in the browser. Cloudgate installs it on a server Cloudgate provides or one you connect, with the database it needs, and gives it a secure web address. It starts empty: sign in as admin, connect your database and build your first chart.

## What you can do with Apache Superset

- **Build charts without code**: Pick a table, drag in the numbers and columns you want, and choose a chart type.
- **Write SQL in the browser**: SQL Lab lets analysts browse tables, run queries, keep a history and turn any result into a chart.
- **Choose from 40+ chart types**: Bar and line charts, pivot tables, big-number tiles, maps and many more come built in.
- **Share interactive dashboards**: Put charts on one page with filters, tabs and cross-filtering, and click through to the rows behind a number.
- **Chart your PostgreSQL data live**: Connect a PostgreSQL database and Superset queries it where it is, without copying the data in.
- **Define metrics once**: Save shared metric definitions on a dataset, so everyone charts revenue or orders the same way.
- **Control who sees what**: Roles and row-level rules can let a sales manager see only their own region, for example.

## Replaces Tableau, Power BI and Looker

Apache Superset does the same job as Tableau, Power BI and Looker. Here is what changes when you switch.

### What you gain

- No licence fee per viewer, so everyone can see the dashboards
- Every feature is in the one free release; there is no paid edition
- A full SQL editor and 40+ chart types, including maps
- Your dashboards and connection details stay on your own server

### What is different

- Your data must already be in a database; this setup reads PostgreSQL, and other databases need an extra driver
- Anything beyond simple charts needs someone comfortable with SQL
- No Excel-style data modelling like Power BI's Power Query, and a lighter data model than Looker
- Existing Tableau, Power BI or Looker dashboards can't be imported; you rebuild them

## What happens when you click Deploy?

Deploy link: https://cloudgate.octabyte.app/get-started?template=superset

1. **Click Deploy and create your account.** Deploy takes you to Cloudgate. Create an account, or log in if you have one. Apache Superset itself is free.
2. **Choose a server.** No server? Get one from Cloudgate: pick a size and a country, and Cloudgate gets it ready. Already have one? Connect it instead.
3. **Cloudgate sets up Apache Superset.** It prepares the server, makes the passwords the app needs and starts it. There is nothing to install and nothing to write down.
4. **Open your app and sign in.** Your app gets a free web address to start, without https. Add your own domain, like app.yourshop.com, and Cloudgate secures it with https for you.

## Questions

### Is Apache Superset free?

Yes, Apache Superset is free and open source under the Apache 2.0 licence, and there is no paid edition, so every feature comes in the one release. You pay only for your server. Preset, a separate company, sells hosted Superset, but you don't need it to self-host.

### Is Apache Superset a good alternative to Tableau or Power BI?

Yes, for teams with someone who knows SQL and data in a database, Apache Superset covers charts, dashboards and shared access with no licence per viewer. Tableau and Power BI are easier for non-technical people, work directly with spreadsheets and offer more design and data-modelling tools.

### Should I choose Apache Superset or Metabase?

Choose Metabase if most people building charts don't know SQL, because its menus are easier to learn. Choose Apache Superset if you have people who write SQL and want a full SQL editor, more chart types and every feature without a paid edition, and you accept more setup.

### Do I need to know SQL to use Apache Superset?

No, not for simple charts on one table or view, which you build from menus in Apache Superset. Combining several tables needs SQL, either in SQL Lab or as a saved query or database view that others can then chart.

### How do I sign in to Apache Superset the first time?

Sign in with the username admin and the password Cloudgate created, which is shown in Cloudgate. Apache Superset starts empty and has no sign-up page, so the admin adds a database under Settings, Database Connections and creates accounts for everyone else.

### Can Apache Superset import my Tableau or Power BI dashboards?

No, Apache Superset can't open Tableau workbooks, Power BI files or Looker models, so you rebuild your dashboards. Superset's own dashboards, charts and datasets can be exported and imported between Superset installs.

### What server size do I need for Apache Superset?

Cloudgate starts Apache Superset on a medium server with 2 GB of memory, which suits a small team. Superset's own FAQ says admins report 8 GB of memory and 2 CPUs as enough for a moderately sized instance, because the size depends on users and activity, not on how much data you have. The first start takes a few minutes.

### Do I need technical skills to run Apache Superset?

No. Click Deploy, create your Cloudgate account and choose a server, and Cloudgate sets up Apache Superset and gives it a web address. You use it in your browser like any other online tool.

### Do I need my own server for Apache Superset?

No. When you deploy Apache Superset, hosted Cloudgate can provide a server. If you already rent one, you can connect it instead.
