×
Community Blog Deploy and Run Superset on Alibaba Cloud with ApsaraDB RDS for PostgreSQL

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

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

This tutorial shows you how to run Apache Superset 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

Superset is a modern data exploration and visualization platform.

To enhance with the database high availability behind the Superset data exploration and visualization, we will show the steps of deployment working with Alibaba Cloud Database Family.

In this tutorial, we will use the Superset image in Alibaba Cloud Marketplace, which is well packaged and configured for easy starting and future version upgrading.

For more administration guide of this Superset image, please refer to: https://support.websoft9.com/docs/superset

Deployment architecture:

2

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

Run the terraform script to initialize the resources.

Within the terraform script, please use the right Image ID of Superset image on the corresponding region.

3
4

After the Terraform script execution, open the following URL in a Web browser to initialize Superset:

http://<ECS_EIP>

5

Please log on to ECS and visit the Superset credential file to get the initial administrator username and password.

ssh root@<ECS_EIP>

vim /credentials/password.txt

6
7

Then back to Superset log on page, and input the administrator user name and password to log on, you will see the main page.

8
9

Step 2. Setup connection to RDS PostgreSQL

On the Superset web page, go to Data -> Databases to add RDS PostgreSQL as a database.

10

In the SQLALCHEMY URI, input the RDS PostgreSQL URI following this pattern: postgresql://<username>:<password>@<rds_postgresql_domain>:<rds_postgresql_port>/<schema>, such as postgresql://superset:superset@pgm-gs5n44yc841r4y5y70490.pgsql.singapore.rds.aliyuncs.com:1921/superset.

Then you can setup Dataset, Chart, Dashboard or work with other BI features on Superset.

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

For more information about database URI in Superset, please refer to https://superset.apache.org/docs/databases/installing-database-drivers.

0 0 0
Share on

ApsaraDB

451 posts | 97 followers

You may also like

Comments