Apache Superset

This page describes how to set up Apache Superset and configure it for use with Rockset.

These steps below require that you have installed the rockset-sqlalchemy package. To install, run:

pip3 install rockset-sqlalchemy


Superset is a data exploration and visualization web application. Refer here to set up Superset in your environment. Superset uses SQLAlchemy to perform operations.


  1. Create an API Key using the Rockset Console under
    Manage > API Keys.

Create New API Key

  1. To add Rockset as a Database source in Superset, navigate to Sources > Databases and click on
    the plus (+) symbol.

Superset add Database

  1. Configure the database as follows:
  • Fill in the database name.
  • Use the format below for the SQLAlchemy URI. Replace {api key} with the your Rockset API key from Step 1 and {region api endpoint} with the host name from one of the region-specific URLs in the Rockset API reference.
    To target a specific virtual instance, replace {virtual instance} with its ID or RNN. To use the default instance, leave {virtual instance} empty.
rockset://{api key}:@{region api endpoint}/{virtual instance}

Note: Do not include the https:// portion of the region-specific URL.

  • Select Expose in SQL Lab.
  • Select Allow DML if you want to run DESCRIBE queries on your collection.
  1. Test the connection and if everything is successful, click Save.

Superset add Rockset


  1. Navigate to SQL Lab > SQL Editor. Select the Rockset Database added in the previous steps and
    select the 'commons' schema. This will populate the table schemas. Select the collection you want
    to run query on.

Superset SQL Lab

  1. Click on Explore to visualize and create dashboards over the query results.

Superset Explore Results

  1. Navigate to Sources > Tables to add Rockset collections as a Table source. Once you're happy
    with how it looks, save and view your application!