Superset Features

This page goes through all the superset features and provides information on how to use them.

Connect to Other Databases

Pro Tip: Ensure you have installed the proper database driver(s) for your database before attempting to establish the connection. You can find more details here.

Superset provides users with a streamlined way to connect to various remote databases, including SQLite, PostgreSQL, and more. This feature enables the integration of remote data for creating dashboards and visualizing charts.

In MEDomicsLab, after launching Superset, you can easily connect to any remote database via the "Connect a Database" interface. To access this, navigate to Settings -> Database Connections

How to open Database Connections Interface

Once the interface is open (see image below), select your desired database—this tutorial uses PostgreSQL as an example.

Database Connections Interface

Then enter your database credentials, such as the host, port, username, and other required details. Refer to the image below for guidance.

Connection interface to PostgreSQL through Superset

Once you hit and CONNECT, you should see a confirmation message as depicted below:

Successful connection to database

If you encounter an error, please refer to the Superset documentation for guidance on troubleshooting the issue. Should the problem persist, feel free to reach out to us for further assistance.

Explore & Visualize

To explore data from your connected dataset, you can use either SQL Lab or the "Add Dataset" option, as illustrated in the figure below:

• SQL Lab: Provides a complete preview of the data, displays column data types, and allows for custom SQL queries on the dataset.

SQL Lab depiction

How to save the output data of your SQL query

• Add new dataset: Lets you explore the columns and their data types, with the ability to create charts based on the data if needed.

Steps to create a dataset and a chart from a connected database

Create Dashboards

One of the main features of Superset is charts and dashboard creation. It offers a no-code procedure for building charts quickly. To do so:

• Create a new dashboard:

Create new dashboard steps

• Create a new chart and add it to the dashboard:

Create new chart and add it to a dashboard

Export Data to Workspace

Superset enables data exportation through SQL Lab. This empowers users to further process and explore their data within MEDomicsLab by leveraging the different tools available.

Export data to your local workspace

Useful resources

• How to configure your Superset?

• Connect to a database.

• How to use Superset (dashboard creation, data exploration, etc.)

• FAQ