All Products
Search

This Product

    Hologres:Apache Superset

    Document Center

    Hologres:Apache Superset

    Last Updated:Feb 04, 2026

    This topic describes how to connect Apache Superset to Hologres for visual data analytics.

    Background information

    Apache Superset (incubating) is an open source business intelligence (BI) tool for data exploration and visual analytics. Apache Superset is developed in Python and uses components such as Flask, Pandas, and SQLAlchemy. Hologres is compatible with PostgreSQL. This topic uses Apache Superset V0.38.0 as an example to demonstrate how to connect to Hologres for data analytics. For more information about Apache Superset, see Why Superset?.

    Prerequisites

    Procedure

    1. Log on to Superset. In the top menu bar, choose Sources > Database Connections. You are redirected to the Databases page.

    2. In the upper-right corner of the page, click DATABASE. You are redirected to the Connect a database page.

    3. On the Connect a database page, select PostgreSQL and configure the data source parameters.

      image

      Parameter

      Description

      HOST

      The network address and port of the Hologres instance.

      Log on to the Hologres console. In the left-side navigation pane, click Instances. On the Instances page, click the ID of the instance. On the Instance Details page, view the endpoint and port number in the Network Information section.

      Important

      Select the correct network address and port based on the network environment where Apache Superset runs. Otherwise, the connection fails.

      PORT

      DATABASE NAME

      The name of the database that you created in Hologres. Log on to the Hologres management console. In the Actions column of the target instance, click Manage. Then, click Database Management. On the Database Authorization page, obtain and confirm the database name.

      USERNAME

      The AccessKey ID of your Alibaba Cloud account. Click AccessKey Management to obtain the AccessKey ID.

      PASSWORD

      The AccessKey secret of your Alibaba Cloud account.

      DISPLAY NAME

      The display name of the database.

      ADDITIONAL PARAMETERS

      Configure additional parameters. Configure the application_name parameter. This helps you quickly identify queries from Superset during later analysis. For example:

      application_name=superset.

      image

    4. Click FINISH to confirm the connection and validation.

      After the settings are saved, you can use the Hologres data source for visual data analytics. For more information, see Apache Superset.