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 in to Metabase. In the upper-right corner of the navigation bar, click the
settings icon and select Admin from the drop-down menu. -
On the Metabase Admin page, click Database at the top, and then click Add database in the upper-right corner to add your Hologres database.
-
Set Database type to PostgreSQL and enter a Name for the connection, such as Hologres. Then, fill in the Host, Port, Database name, AccessKey ID, and AccessKey Secret. Leave the Use a secure connection (SSL)? option disabled. When you are finished, 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 your Hologres instance. You can find this endpoint in the Network Information section of the Instance Details page in the Hologres console.
Port
The port for your Hologres instance. You can find this port 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
Once connected, you can analyze your Hologres data in Metabase. For more details on analysis features, see the official Metabase documentation. For example, to create a combination chart, set the X-axis to Nation → N Name and add two series to the Y-axis: L Quantity as a bar chart and L Discount as a line chart. The resulting chart compares quantity and discount data across 25 countries. Use the options in the left panel to configure Display, Axes, Labels, and Data. When finished, click Done.