This topic describes how to connect Apache Superset to Hologres and analyze data in a visualized manner.
Background information
Apache Superset (incubating) is an open source BI tool that is used for data exploration and visualized data analysis. Apache Superset is developed based on Python by using components such as Flask, Pandas, and SQLAlchemy. Hologres is compatible with PostgreSQL. In this example, Apache Superset V0.38.0 is connected to Hologres for data analysis. For more information about Apache Superset, see Why Superset?
Prerequisites
A Hologres instance is purchased. For more information, see Purchase a Hologres instance.
Apache Superset is installed. For more information, visit the Apache Superset official website.
Procedure
Log on to Apache Superset and choose in the top navigation bar.
In the upper-right corner of the Databases page, click DATABASE.
In the Connect a database dialog box, select PostgreSQL as the database and configure data source parameters. The following table describes the parameters.
Parameter
Description
HOST
The endpoint and port number 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.
ImportantSelect the correct endpoint and port number based on the network environment where Apache Superset is running. Otherwise, the connection will not work properly.
PORT
DATABASE NAME
The name of the Hologres database. You can log on to the Hologres console, find the Hologres instance, and then click Manage in the Actions column. In the left-side navigation pane of the Instance Details page, click Database Management. On the Database Authorization page, you can obtain the database name.
USERNAME
The AccessKey ID of the Alibaba Cloud account. You can obtain the AccessKey ID from the AccessKey Pair page.
PASSWORD
The AccessKey secret of the Alibaba Cloud account.
DISPLAY NAME
The display name of the database.
ADDITIONAL PARAMETERS
The additional parameter that you want to configure. We recommend that you configure the
application_nameparameter to quickly identify queries that are initiated by Apache Superset. Example:application_name=superset.
Click FINISH and confirm that the database is connected.
After the configurations are saved, you can connect Apache Superset to Hologres to analyze and display data in a visualized manner. For more information, see Connecting to Databases.