Metabase is an open source business intelligence (BI) tool. You can use Metabase to understand and analyze data, or query data to obtain formatted results such as graphical views. This helps you make decisions based on data. Hologres is compatible with PostgreSQL. Hologres allows you to connect to Metabase for data analytics. This topic describes how to connect Metabase to Hologres. After Metabase is connected to Hologres, you can analyze data in Hologres in a visualized manner.
Usage notes
After you connect Metabase to Hologres and read metadata from a database in Hologres, Metabase automatically filters out schemas that contain no tables. The schemas are not displayed in the data list.
Procedure
Install Metabase.
Install Metabase. For more information, see Installing Metabase.
Connect Metabase to Hologres.
Log on to Metabase. In the upper-right corner of the top navigation bar, click the icon and select Admin from the shortcut menu.
On the Metabase Admin page, click Database in the top navigation bar. On the Databases tab, click Add database in the upper-right corner and create a connection to Hologres.
After you select the type of a database to be connected and configure relevant parameters, click Save.
The following table describes the parameters.
Parameter
Description
Database type
The type of the database to be connected. Select PostgreSQL from the drop-down list.
Host
The public endpoint of the Hologres instance. You can view the endpoint of the Hologres instance in the Network Information section of the Instance Details page in the Hologres console.
Port
The port number of the Hologres instance. You can view the port number of the Hologres instance in the Network Information section of the Instance Details page in the Hologres console.
Database name
The name of the Hologres database.
AccessKey ID
The AccessKey ID of the Alibaba Cloud account used to connect to the Hologres database. For more information about how to obtain the AccessKey ID, see Create an Alibaba Cloud account.
AccessKey Secret
The AccessKey secret of the Alibaba Cloud account used to connect to the Hologres database. For more information about how to obtain the AccessKey secret, see Create an Alibaba Cloud account.
Other parameters
For more information about other parameters, see Metabase Documentation.
Overview
After settings are complete, you can connect Metabase to Hologres for data analytics. For more information about the operations of data analytics, see Adding and managing databases.
Note