• Querying Your Data
  • Visualization Tools
  • Superset Integration

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.

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 following format for SQLAlchemy URI: rockset://apikey:{your-apikey}@api.rs2.usw2.rockset.com/ Replace your-apikey with the your Rockset API key from Step 1.
  • 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

#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

  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!
Join us on Slack!
Building on Rockset? Come chat with us!