Superset Integration

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 latest Rockset Python SDK. For instructions on doing so, refer here.

Introduction

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

Configuration

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

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

3. Configure the database as follows:

• Fill in the database name.

• Use the following format for SQLAlchemy URI: rockset://apikey:{your-apikey}@{region api endpoint}/ Replace your-apikey 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.

  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.

4. Test the connection and if everything is successful, click Save.

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.

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

3. 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!