Architecture Center
Deploy and Run Superset on Alibaba Cloud

Deploy and Run Superset on Alibaba Cloud

Overview
Superset is a modern data exploration and visualization platform. This solution deploys Superset on Alibaba Cloud to enhance the high availability of Alibaba Cloud database family.
This solutuion uses the Superset image in Alibaba Cloud Marketplace, which is well packaged and configured for easy starting and future version upgrading. For detailed information of this Superset image, please refer to Superset Administrator Guide.
Reference Architectures
Steps
Deploy Resources
Use this main.tf file in Terraform to provision ECS and other resources from this solution.
Note: Use the correct Image ID of WordPress image on the corresponding region.
Set Up Connection to RDS PostgreSQL
1 Visit the following URL in a web browser to initialize Superset.
http://ECS_EIP
2 Run the following command to 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
3 Go back to Superset logon page, and input the administrator user name and password to log on.
4 Go to "Data>Databases" to add RDS PostgreSQL to the database list.
5 In the "SQLALCHEMY URI", input the RDS PostgreSQL URI in the following format.
postgresql://username:password@rds_postgresql_domain:rds_postgresql_port/schema
Here is an example: postgresql://superset:superset@pgm-gs5n44yc841r4y5y70490.pgsql.singapore.rds.aliyuncs.com:1921/superset.
6 Set up Dataset, Chart, Dashboard or work with other BI features on Superset.
Connect Superset to other databases on Alibaba Cloud.
For ApsaraDB RDS for MySQL, refer to https://superset.apache.org/docs/databases/mysql
For ApsaraDB RDS for PostgreSQL, refer to: https://superset.apache.org/docs/databases/postgres
For ApsaraDB RDS for SQL Server, refer to: https://superset.apache.org/docs/databases/sql-server
For PolarDB for MySQL, refer to: https://superset.apache.org/docs/databases/mysql
For PolarDB for PostgreSQL, refer to reference: https://superset.apache.org/docs/databases/postgres
For PolarDB for Oracle, connection URI reference: https://superset.apache.org/docs/databases/postgres
For AnalyticDB for MySQL, refer to: https://superset.apache.org/docs/databases/mysql
For AnalyticDB PostgreSQL, refer to: https://superset.apache.org/docs/databases/postgres
For ApsaraDB for ClickHouse, refer to: https://superset.apache.org/docs/databases/clickhouse

Reach Alibaba Cloud experts for support

Contact Us