Skip to main content
Version: 3.1

Apache Superset

Apache Superset supports querying and visualizing both internal data and external data in StarRocks.

Prerequisites​

Make sure that you have finished the following installations:

  1. Install the Python client for StarRocks on your Apache Superset server.

    pip install starrocks

  2. Install the latest version of Apache Superset. For more information, see Installing Superset.

Integration​

Create a database in Apache Superset:

Apache Superset - 1

Apache Superset - 2

Take note of the following points:

  • For SUPPORTED DATABASES, select StarRocks, which will be used as the data source.

  • For SQLALCHEMY URI, enter a URI in the StarRocks SQLAlchemy URI format as below:

    starrocks://<User>:<Password>@<Host>:<Port>/<Catalog>.<Database>

    The parameters in the URI are described as follows:

    • User: the username that is used to log in to your StarRocks cluster, for example, admin.
    • Password: the password that is used to log in to your StarRocks cluster.
    • Host: the FE host IP address of your StarRocks cluster.
    • Port: the FE query port of your StarRocks cluster, for example, 9030.
    • Catalog: the target catalog in your StarRocks cluster. Both internal and external catalogs are supported.
    • Database: the target database in your StarRocks cluster. Both internal and external databases are supported.