Deploy and Run Redash on Alibaba Cloud with ApsaraDB RDS for PostgreSQL

This tutorial shows you how to run Redash on Alibaba Cloud with ApsaraDB RDS for PostgreSQL.

You can access all the tutorial resources, including deployment script (Terraform), related source code, sample data, and instruction guidance, from the GitHub project: https://github.com/alibabacloud-howto/opensource_with_apsaradb/tree/main/apache-superset

For more tutorials around Alibaba Cloud Database, please refer to: https://github.com/alibabacloud-howto/database

Overview

Redash is designed to enable anyone, regardless of the level of technical sophistication, to harness the power of data — big and small. SQL users leverage Redash to explore, query, visualize, and share data from any data sources. Their work in turn enables anybody in their organization to use the data. Every day, millions of users at thousands of organizations around the world use Redash to develop insights and make data-driven decisions.

To enhance Redash data exploration and visualization with a high availability database, we will show the steps of deploying and working with Alibaba Cloud ApsaraDB RDS for PostgreSQL database.

In this tutorial, we will use the official setup script to deploy Redash with Docker on Ubuntu on Alibaba Cloud ECS.

Deployment architecture:

Step 1. Use Terraform to Provision ECS Image and Database on Alibaba Cloud

Run the terraform script to initialize the resources (in this tutorial, we use RDS PostgreSQL as example data source for Redash, so ECS and RDS PostgreSQL instances are included in the Terraform script). Please specify the necessary information and region to deploy.

After the Terraform script execution finished, the ECS and RDS PostgreSQL instance information are listed as below.

Step 2. Deploy and Set up Redash on ECS

Please log on to ECS with ECS EIP.

ssh root@<ECS_EIP>

Then execute the following commands to setup the Redash.

mkdir /opt/redash
wget https://raw.githubusercontent.com/getredash/setup/master/setup.sh
sh setup.sh

After the setup script execution finished, open the following URL in a Web browser to initialize Redash:

http://<ECS_EIP>

Step 3. Set up Connection to RDS PostgreSQL

On the Redash main page, click Connect a data source to add RDS PostgreSQL as a source database.

Input the RDS PostgreSQL instance connection string and port that we got in Step 1.

Then you can create Query, Dashboard or work with other BI features on Redash.

You can use Redash to connect to the following database types on Alibaba Cloud:

RDS MySQL, refer to Redash features for MySQL: https://redash.io/data-sources/mysql
RDS PostgreSQL, refer to Redash features for PostgreSQL: https://redash.io/data-sources/postgresql
RDS SQL Server, refer to Redash features for SQL Server: https://redash.io/data-sources/microsoft-sql-server
PolarDB MySQL, refer to Redash features for MySQL: https://redash.io/data-sources/mysql
PolarDB PostgreSQL, refer to Redash features for PostgreSQL: https://redash.io/data-sources/postgresql
PolarDB-O, refer to Redash features for PostgreSQL: https://redash.io/data-sources/postgresql
MongoDB, refer to Redash features for MongoDB: https://redash.io/data-sources/mongodb
AnalyticDB MySQL, refer to Redash features for MySQL: https://redash.io/data-sources/mysql
AnalyticDB PostgreSQL, refer to Redash features for Greenplum: https://redash.io/data-sources/greenplum
ClickHouse, refer to Redash features for ClickHouse: https://redash.io/data-sources/clickhouse

For more information about supported data sources in Redash, please refer to https://redash.io/integrations/.

Community

Deploy and Run Redash on Alibaba Cloud with ApsaraDB RDS for PostgreSQL

Overview

Step 1. Use Terraform to Provision ECS Image and Database on Alibaba Cloud

Step 2. Deploy and Set up Redash on ECS

Step 3. Set up Connection to RDS PostgreSQL

Read previous post:

Read next post:

ApsaraDB

You may also like

Comments

ApsaraDB

Related Products

ApsaraDB RDS for PostgreSQL

PolarDB for PostgreSQL

ApsaraDB RDS for MySQL

ApsaraDB RDS for SQL Server