​
Prerequisites

  • Access to a StarTree Cloud cluster.
  • Access to a Superset instance.
    For more information about how to install and deploy Superset, see What is Apache Superset?
  • Superset instance has the Pinot database driver installed, which is compatible with StarTree Cloud. For more information, see how to install a database driver for Superset.

​
Obtain the SQLAlchemy URI to connect to StarTree

  1. Visit the apps page of your cluster.
  2. Click on the Pinot API Tokens button.
  3. On the API Tokens page, select Clients from the left hand sidebar.
  4. Click on Superset in the client options.
  5. Click Create a new API Token.
  6. Copy the SQLAlchemy URI.

​
Create the Database Connection in Superset

  1. In Superset, click Settings in the top-right corner and select Database Connections under the Data section.
  2. Click the + Database button.
  3. Open the Choose a Database dropdown and select Apache Pinot.
    If Apache Pinot is not listed, see the instructions to configure the Apache Pinot database driver.
  4. Specify a name for the database connection
  5. Paste the SQLAlchemy URI that you copied from StarTree.
  6. Test the connection.