Redash is an open source business intelligence (BI) tool that is used for data visualization. It also provides features such as alerting and subscription. Compatible with PostgreSQL, Hologres allows you to connect your Hologres instance to Redash for data analysis. This topic describes how to connect Redash to Hologres and analyze Hologres data in Redash in a visualized manner.

Procedure

  1. Install Redash.
    For more information, see the Redash documentation.
  2. Connect Redash to your Hologres instance.
    1. Log on to Redash. Click the Settings icon icon in the upper-right corner and select Data Sources. data source
    2. On the Data Sources tab of the Settings page, click New Data Source. Create a connection
    3. In the Create a New Data Source dialog box, select PostgreSQL in the Type Selection step, set the parameters as needed in the Configuration step, and then click Create. A connection is created. You can view the data of your Hologres instance in Redash. Create a connection
      Step, parameter, or value Description
      Type Selection PostgreSQL When you select a type for the connection, search for PostgreSQL in the search box and click PostgreSQL.
      Configuration Host The public endpoint of your Hologres instance. You can view the public endpoint of the Hologres instance on the Configurations tab of the instance details page in the Hologres console.
      Port The port number of your Hologres instance. You can view the port number of the Hologres instance on the Configurations tab of the instance details page in the Hologres console.
      User The AccessKey ID of your Alibaba Cloud account. For information about how to obtain the AccessKey pair, see Create an Alibaba Cloud account.
      Password The AccessKey secret of your Alibaba Cloud account. For information about how to obtain the AccessKey pair, see Create an Alibaba Cloud account.
      Database Name The name of the Hologres database to which you want to connect.
  3. In the top navigation bar, choose Create > New Query. On the New Query page, enter an SQL statement in the field in the right-side pane of the page. new query
  4. After the SQL statement is executed, you can create a visual chart based on the query results. Visual chart
    For more information about how to write query statements and create visual charts in Redash, see the Redash documentation.