Redash is an open source Business Intelligence (BI) tool for data visualization. It also provides features such as alerts and subscriptions. Hologres is compatible with PostgreSQL and supports direct connections to Redash for data analytics. This topic describes how to connect Redash to Hologres and perform visual analytics on data.
Procedure
-
Install Redash.
For more information, see the official Redash documentation.
-
Connect to Hologres.
-
Log on to Redash. In the upper-right corner of the page, click the
icon and select Data Sources from the drop-down list.
-
Go to the New Data Source tab and click +New Data Source to add a data source.
-
On the page that appears, configure the parameters and click Create. You can then view your Hologres data in Redash.
Parameter
Description
Type Selection
PostgreSQL
Search for PostgreSQL and click it to add the data source.
Configuration
Host
The public endpoint of the Hologres instance. Go to the instance product page in the Hologres console. Find the endpoint in the Network Information section.
Port
The port of the Hologres instance. Go to the instance product page in the Hologres console. Find the port in the Network Information section.
User
The AccessKey ID of your Alibaba Cloud account. For more information, see Create an AccessKey pair.
Password
The AccessKey secret of your Alibaba Cloud account. For more information, see Create an AccessKey pair.
Database Name
The name of the database created in Hologres.
-
-
At the top of the page, choose . You can write SQL statements in the editor.
-
After you write the SQL statement, create a visualization chart.
For more information about how to write queries and create visualizations in Redash, see the official Redash documentation.