Apache Superset-Hologres(Hologres)-阿里云帮助中心

This topic shows how to connect Apache Superset to Hologres for visual data analysis.

Background

Apache Superset (incubating) is an open-source business intelligence (BI) tool for data exploration and visual data analysis. It is built in Python and uses components like Flask, Pandas, and SQLAlchemy. Hologres is compatible with PostgreSQL. This guide demonstrates the connection process using Apache Superset v0.38.0. For more information about Apache Superset, see Why Superset?.

Prerequisites

You have a Hologres instance. For instructions, see Purchase a Hologres instance.
You have installed Apache Superset. For details, see the Apache Superset official website.

Procedure

Log on to Superset. From the top menu bar, choose Sources > Databases Connections to go to the Databases page.
In the upper-right corner of the page, click + DATABASE to go to the Connect a database page.

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

Parameter	Description
Host	The endpoint and port of your Hologres instance. Log on to the Hologres console. In the left-side navigation pane, click Instances. Click your target instance. On the Instance Details page, get the endpoint and port from the Network Information section. Important Use the endpoint and port that match the network environment of your Apache Superset deployment. Otherwise, the connection will fail.
Port
Database name	The name of the database that you created in Hologres. To find the database name, log on to the Hologres console. In the instance list, find your target instance and click Manage in the Actions column. Then, click Database Management to find the database name on the Database Authorization page.
Username	The AccessKey ID for your Alibaba Cloud account. You can get your AccessKey ID from the AccessKey Management page.
Password	The AccessKey Secret for your Alibaba Cloud account.
Display name	A user-friendly name for the database connection.
Additional parameters	Configure additional parameters. We recommend setting the `application_name` parameter to easily identify Superset queries during analysis. For example: `application_name=superset`

Click FINISH.

After the connection is saved, you can connect to Hologres to visualize and analyze your data. For more information, see the Apache Superset documentation.