Streambased Documentation
  • Home
  • Overview
    • Key Concepts
  • Streambased Cloud
    • Streambased Cloud UI
      • Create your first Streambased cluster
      • Create your first Streambased API Key
      • Running your first A.S.K Query
      • Exploring your data using S.S.K
    • Iceberg Service for Kafka - I.S.K.
      • Overview
      • Architecture
      • Usage
      • Quick Start
    • Analytics Service for Kafka - A.S.K.
      • Overview
      • Architecture
      • Connecting to Streambased A.S.K.
        • Connect Superset to Streambased A.S.K.
        • Connect Jupyter to Streambased A.S.K.
        • Connect a JDBC Client to Streambased A.S.K.
        • Connect an ODBC client to Streambased A.S.K.
        • Connect a Python Application (SQL Alchemy) to Streambased A.S.K.
    • Storage Service for Kafka - S.S.K.
      • Overview
      • Connecting to Streambased S.S.K.
        • Connecting a S3 compatible client to Streambased S.S.K.
        • Connect a S3manager to Streambased S.S.K.
  • Streambased Platform
    • Overview
    • Requirements
    • Step by Step Installation
    • Configuration
    • Connecting Analytical Applications to Streambased
      • Connect Superset to Streambased
      • Connect Jupyter to Streambased
      • Connect a JDBC Client to Streambased
      • Connect an ODBC client to Streambased
      • Connect a Python Application (SQL Alchemy) to Streambased
Powered by GitBook
On this page
  • Prerequisites:
  • Step 1: Fetch your login credentials
  • Step 2: Add a Database
  • Step 3: Configure the database
  • Step 4: Test the connection
  • Step 5: Run some queries
  1. Streambased Cloud
  2. Analytics Service for Kafka - A.S.K.
  3. Connecting to Streambased A.S.K.

Connect Superset to Streambased A.S.K.

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

PreviousConnecting to Streambased A.S.K.NextConnect Jupyter to Streambased A.S.K.

Last updated 2 months ago

Prerequisites:

  • An active Streambased Cloud account, sign up or log in

  • A running Superset deployment

Step 1: Fetch your login credentials

Access to Streambased Cloud is managed via API-keys, you can create one for you new connection

With Superset you will use your public key as the database username and your secret key as the database password. Make a note of these for Step 3.

Step 2: Add a Database

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

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

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://[username]:[password]@ask-beta.streambased.cloud:8443/kafka

Replace [username] and [password] with the values from Step 1

Then go to the ADVANCED tab then OTHER and add the following in the ENGINE PARAMETERS text box:

{"connect_args":{"http_scheme":"https","schema":"streambased"}}

Step 4: Test the connection

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

Step 5: Run some queries

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

here
here
Add a database
Select Trino
A successful connection
Execute SQL