Redash connection
Redash is an open-source Business Intelligence (BI) tool that provides features such as data visualization, alerting, and subscriptions. AnalyticDB for PostgreSQL supports direct connections to Redash for data analysis. This topic describes how to connect Redash to AnalyticDB for PostgreSQL and perform visual data analysis.
Prerequisites
-
An AnalyticDB for PostgreSQL instance.
-
Redash is installed. For more information, see the official Redash documentation.
Procedure
-
Log on to Redash. In the upper-right corner, click the
icon and select Data Sources from the drop-down list. -
On the New Data Source tab, click +New Data Source.
-
In the dialog box, configure the following parameters:
Parameter
Description
Type selection
PostgreSQL
Search for and select PostgreSQL.
Configuration
Host
The internal endpoint of your AnalyticDB for PostgreSQL instance. To obtain the endpoint, go to the Database Connection page for your instance in the AnalyticDB for PostgreSQL console.
Port
The port of your AnalyticDB for PostgreSQL instance. The default value is 5432.
User
Your AccessKey ID. For information about how to obtain an AccessKey ID, see Create an AccessKey pair.
Password
Your AccessKey secret. For information about how to obtain an AccessKey secret, see Create an AccessKey pair.
Database name
The name of the database in your AnalyticDB for PostgreSQL instance.
-
After configuring the parameters, click Create. You can then view data from your AnalyticDB for PostgreSQL instance in Redash.
-
At the top of the page, select . Write SQL statements in the editor.
-
After writing and running the SQL statement, you can create a visualization from the results.
For more information about writing queries and creating visualizations in Redash, see the official Redash documentation.