Connect Superset to Streambased

Superset is a modern, open source data exploration and visualization platform. Let's supercharge it's capabilities with real-time data from Streambased.

Prerequisites:

  • A running Streambased instance, for instructions see here

  • A running Superset deployment

Step 1: Add a Database

Locate the Settings button in the top right and select Database Connections

Add a database

In the resulting screen select + Database and select Trino as the database type:

Select Trino

Step 3: Configure the database

In the resulting screen under basic tab configure the following properties:

Property Name
Value

DISPLAY NAME

Streambased #(or other meaningful name to you)

SQLALCHEMY URI

trino://[server host]:[server port]/kafka

By default server port is 8080 and server host is the name of the host on which the docker instance has been launched.

Step 3: Test the connection

Click TEST CONNECTION, you should receive a message similar to the following:

A successful connection

Step 4: Run some queries

From the menu bar select SQL -> SQL LAB, you should see your Streambased database and schema listed. Happy querying!

Execute SQL

Last updated