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.
Deployment architecture:
If you are the 1st time to use Terraform, please refer to here to learn how to install and use the Terraform on different operating systems.
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:
http://<ECS_EIP>
Please log on to ECS and visit the Superset credential file to get the initial administrator username and password. By default, the password is N1cetest, which is preset in the terraform provision script in Step 1. If you've already changed it, please update accordingly.
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 Data -> Databases to add PolarDB for PostgreSQL as a database.
In the SQLALCHEMY URI, input the URI of PolarDB for PostgreSQL following this pattern: postgresql://<username>:<password>@<polardb_pg_domain>:<polardb_pg_port>/<schema>, such as postgresql://superset:superset@pc-gs5n44yc841r4y5y70490-public.pg.polardb.singapore.rds.aliyuncs.com:1921/superset.
Then you can setup Dataset, Chart, Dashboard or work with other BI features on Superset.