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
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.
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.
Please log on to ECS with
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:
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
Dashboard or work with other BI features on Redash.
You can use Redash to connect to the following database types on Alibaba Cloud:
For more information about supported data sources in Redash, please refer to https://redash.io/integrations/.
Deploy and Run Netflix Dispatch on Alibaba Cloud with ApsaraDB RDS for PostgreSQL
Deploy and Run Superset on Alibaba Cloud with ApsaraDB RDS for PostgreSQL
Alibaba Cloud MaxCompute - February 17, 2021
ApsaraDB - September 23, 2021
ApsaraDB - September 8, 2021
ApsaraDB - September 7, 2021
ApsaraDB - October 14, 2021
ApsaraDB - September 27, 2021
An on-demand database hosting service for PostgreSQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
An on-demand database hosting service for MySQL, SQL Server and PostgreSQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
An on-demand database hosting service for MySQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
Fully managed and less trouble database servicesLearn More
More Posts by ApsaraDB