Redash is an open source business intelligence (BI) tool that is used for data visualization. It also provides features such as alerting and subscription. Hologres is compatible with PostgreSQL. You can connect your Hologres instance to Redash for data analytics. This topic describes how to connect Redash to Hologres and analyze Hologres data in Redash in a visualized manner.
Procedure
Install Redash.
For more information, see the Redash documentation.
Connect Redash to your Hologres instance.
Log on to Redash. Click the icon in the upper-right corner and select Data Sources.
On the Data Sources tab of the Settings page, click New Data Source.
In the Create a New Data Source dialog box, select PostgreSQL in the Type Selection step, configure the parameters in the Configuration step, and then click Create. After the connection is created, you can view the data of your Hologres instance in Redash.
Parameter
Description
Type Selection
PostgreSQL
In this step, search for PostgreSQL in the search box and click PostgreSQL.
Configuration
Host
The public endpoint of the Hologres instance. You can obtain the endpoint of the Hologres instance from the Network Information section of the Instance Details page in the Hologres console.
Port
The port number of the Hologres instance. You can obtain the port number of the Hologres instance from the Network Information section of the Instance Details page in the Hologres console.
User
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.
Password
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.
Database Name
The name of the Hologres database.
In the top navigation bar, choose . On the New Query page, enter an SQL statement in the field in the right-side pane of the page.
After the SQL statement is executed, you can create a visual chart based on the query results.
For more information about how to write query statements and create visual charts in Redash, see the Redash documentation.