# Apache Superset

## Starting out with Superset

Superset is available in Nuvolos spaces where [Tables are activated](https://docs.nuvolos.com/features/database-integration/view-tables#activating-tables).&#x20;

To add it to your instance, open **Applications**, select **Superset**, choose the latest available version, and enter a name for the application. After the application is added, start it. If your instance already contains many tables, the initial load may take a few minutes.

When the application opens, sign in with:

* **Username:** `admin`
* **Password:** `admin`

### Running queries

After you sign in, the Nuvolos connection is already configured in Superset as a Database, and the tables in your instance are already available as Datasets. Open a dataset to preview and query its data without writing SQL. You can also export the query results as a CSV file.

### SQL Lab

To write SQL queries or execute SQL DDL statements, open the SQL editor from the SQL Lab menu. If you want to use a query result for charting, select Explore to save that query as a virtual dataset.

### Uploading CSV files

To upload a CSV file as a dataset, open Data > Upload a CSV. Superset supports small CSV uploads of fewer than 1 million rows. When naming the target table, use an UPPERCASE table name.

### Creating charts and dashboards

You can create charts from either:

* pre-created Datasets based on Nuvolos tables, or
* saved SQL Lab queries that have been stored as virtual datasets.

To create a chart:

1. Open Charts.
2. Select + CHART.
3. Choose the dataset you want to use.
4. Select the chart type.
5. Configure the fields to plot, including the series, grouping, aggregations, and values.

After creating the charts you need, create a dashboard and arrange the charts in the desired layout.

### Further reference

The official Apache Superset documentation is available at: <https://superset.apache.org/docs>.
