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.
Prerequisites:
An active Streambased Cloud account, sign up or log in here
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 here
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:
DISPLAY NAME
Streambased #(or other meaningful name to you)
SQLALCHEMY URI
trino://[username]:[password]@ask-beta.streambased.cloud:8443/kafka
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!
Last updated