Metabase is an open source business intelligence tool. It helps you understand and analyze data, run queries, and view formatted results, such as graphs, to make data-driven decisions. Hologres is compatible with PostgreSQL and supports direct connections to Metabase for data analytics. This topic describes how to connect Metabase to Hologres and perform visual analytics on your data.
Notes
When Metabase connects to Hologres and reads the database metadata, it automatically filters out schemas that do not contain any tables. These schemas are not displayed in the data list.
Procedure
-
Install Metabase
Install Metabase. For more information, see the official Metabase documentation.
-
Connect to Hologres
-
Log on to Metabase. In the upper-right corner of the top navigation bar, click the
icon, and then click Administrator from the drop-down menu.
-
At the top of the Metabase Admin page, click Database. In the upper-right corner of the Databases page, click Add database.

-
Select a database type, configure the connection parameters, and then click Save.

The following table describes the parameters.
Parameter
Description
Database type
From the drop-down list, select PostgreSQL.
Host
The public endpoint of the Hologres instance. You can find the endpoint in the Network Information section on the instance details page of the Hologres console.
Port
The port of the Hologres instance. You can find the port in the Network Information section on the instance details page of the Hologres console.
Database name
The name of the Hologres database.
Username
The AccessKey ID of your Alibaba Cloud account. To obtain an AccessKey ID, see Create an AccessKey pair.
Password
The AccessKey secret of your Alibaba Cloud account. To obtain an AccessKey secret, see Create an AccessKey pair.
More parameters
For more information about other parameters, see the official Metabase documentation.
-
-
Analyze data
After the configuration is complete, you can analyze your data in Hologres. For more information about data analytics, see the official Metabase documentation.
Note