Starter Guide | Build BI Dashboard By PostgreSQL, Cube and React in One Click

This article focuses on one-click deployment through the Alibaba Cloud console. If you need to use scripting for automated deployment, you can refer to this article that uses Terraform.

Overview

Cube is the headless API layer that connects cloud data warehouses to your front end code so you can build data applications faster.

Billing Instructions

The expenses on BI Dashboard mainly involve：

Selected vCPU and memory specifications
System disk type and capacity
Public network bandwidth
ApsaraDB RDS for PostgreSQL specifications and storage space

Deployment Architecture

Parameter Description

Parameter Group	Parameter item	Illustrate
Service Instance	Service Instance Name	The name can be up to 64 characters in length, and can contain digits, letters, hyphens (-), and underscores (_). The name must start with a letter.
	Region	The region where the service instance is deployed.
	Instance Charge Type	Charge type for the service instance.
ECS instance configuration	Instance Type	ECS instance type
	Instance Password	Server login password, Length 8-30, must contain three(Capital letters, lowercase letters, numbers, ()`~!@#$%^&*_-+={}[]:;'<>,.?/ Special symbol in)
network configuration	Availability Zone	The availability zone where the ECS instance is located
	VPC ID	VPC where resources are located
	VSwitch ID	The availability zone of the VSwitch
PostgreSQL configuration	Instance specifications	The specifications of PostgreSQL instances that can be used in the availability zone
	Storage	Instance Storage

Permissions Required

Deploying this service instance requires accessing and creating some Alibaba Cloud resources. Therefore, your account needs to include permissions for the following resources.

Note: You only need to add this permission when your account is a RAM account.

Permission policy name	Remarks
AliyunECSFullAccess	Permission to manage cloud server service (ECS)
AliyunVPCFullAccess	Permission to manage private network (VPC)
AliyunROSFullAccess	Permission to manage Resource Orchestration Service (ROS)
AliyunComputeNestUserFullAccess	Manage user-side permissions for the ComputeNest service (ComputeNest)
AliyunPostgreSQLFullAccess	Manage permissions for cloud database services (PostgreSQL)

Deployment Steps

1. Visit Deployment Link and fill in the deployment parameters as prompted: Deployment link

2. After filling in the deployment link parameters, you can see the corresponding inquiry details. After confirming the parameters, click Next step: Confirm the order.