SQL Clients > Apache Superset

Apache Superset

This page describes how to setup Superset and configure it for use with Rockset.

This guide requires that you have installed the latest Rockset Python client. For instructions on doing so, refer to the instructions here.

Introduction

Apache Superset is a data exploration and visualization web application. Refer here to setup Superset in your environment.

Superset uses SQLAlchemy to perform operations. Install Rockset Python client (version 0.5.13 or higher) in your environment to connect Superset with Rockset.

Configuration

  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 following format for SQLAlchemy URI: rockset://{apiKey}@api.rs2.usw2.rockset.com/ Replace apiKey with the your own API key that you have generated using the Rockset console.
  • Select Expose in SQL Lab.
  • Select Allow DML if you want to run DESCRIBE queries on your collection.

You can test the connection and if everything seems fine, click Save.

Superset add Rockset

Usage

  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

Limitations

  • Adding Rockset collection as a Table source.
  • Date/Time/Datetime field formats.