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
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
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.
After the Terraform script execution, open the following URL in a Web browser to initialize Superset:
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
Then back to Superset log on page, and input the administrator user name and password to log on, you will see the main page.
On the Superset web page, go to
Databases to add RDS PostgreSQL as a database.
SQLALCHEMY URI, input the RDS PostgreSQL URI following this pattern:
postgresql://<username>:<password>@<rds_postgresql_domain>:<rds_postgresql_port>/<schema>, such as
Then you can setup
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.
Deploy and Run Redash on Alibaba Cloud with ApsaraDB RDS for PostgreSQL
Deploy MongoDB Instances in Multiple Regions Automatically Using Terraform
ApsaraDB - September 7, 2021
ApsaraDB - September 7, 2021
ApsaraDB - September 2, 2021
ApsaraDB - September 8, 2021
ApsaraDB - September 23, 2021
Alibaba Cloud MaxCompute - February 17, 2021
Fully managed and less trouble database servicesLearn More
An online MPP warehousing service based on the Greenplum Database open source programLearn More
An on-demand database hosting service for PostgreSQL with automated monitoring, backup and disaster recovery capabilitiesLearn More
Marketplace is an online market for users to search and quickly use the software as image for Alibaba Cloud products.Learn More
More Posts by ApsaraDB