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.

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:

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.

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.

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.

Step 2. Setup connection to RDS PostgreSQL

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

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:

RDS MySQL, connection URI reference: https://superset.apache.org/docs/databases/mysql
RDS PostgreSQL, connection URI reference: https://superset.apache.org/docs/databases/postgres
RDS SQL Server, connection URI reference: https://superset.apache.org/docs/databases/sql-server
PolarDB MySQL, connection URI reference: https://superset.apache.org/docs/databases/mysql
PolarDB PostgreSQL, connection URI reference: https://superset.apache.org/docs/databases/postgres
PolarDB-O, connection URI reference: https://superset.apache.org/docs/databases/postgres
AnalyticDB MySQL, connection URI reference: https://superset.apache.org/docs/databases/mysql
AnalyticDB PostgreSQL, connection URI reference: https://superset.apache.org/docs/databases/postgres
ClickHouse, connection URI reference: https://superset.apache.org/docs/databases/clickhouse

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

Community

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

Overview

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

Step 2. Setup connection to RDS PostgreSQL

Read previous post:

Read next post:

ApsaraDB

You may also like

Comments

ApsaraDB

Related Products

PolarDB for PostgreSQL

Database Overview

AnalyticDB for PostgreSQL

Marketplace