storage-compute decoupled DWS 3.0 uses the cloud-native, cost-effective architecture with decoupled storage and computing.

When storage and computing are separated, VWs are automatically created during peak hours to reduce service load. VWs are automatically scaled based on service load, reducing costs and improving efficiency.

DWS provides you with a one-stop data development tool, that is, the online SQL editor, for data development, access, and processing.

Data Warehouse Service quickly creates a DWS cluster and performs table creation, data insertion, and simple queries.

Common operations on the Huawei Cloud management console, such as scaling, restarting, and viewing cluster monitoring metrics for Data Warehouse Service.

The snapshot function of the Data Warehouse Service backs up all or incremental data of the cluster at a certain point in time. It records the current database data and related cluster information.

The resource load management function of the Data Warehouse Service enables multiple users to execute SQL jobs without affecting each other and saves resource consumption.

Data Warehouse Service console provides a graphical SQL tool for daily operations, including connecting to clusters and executing SQL scripts.

DWS uses a typical role-based access control (RBAC) model to manage users, roles, and permissions. Permissions are used to control whether a user is allowed to access database objects to perform operations. 

The process of importing data from a remote server into DWS using the GDS tool helps you learn how to import data using GDS.

In a decoupled architecture,compute and storage resources can be scaled independently.You do not need to redistribute data when adding compute.The sacling is faster and more flexible.

Materialized views pre-calculate and store query results.When a query is initiated,materialized views can be queried and directly reture results,improving query performance.

The traffic checkpoint vehicle passage simulation data is imported into a single database table in the data warehouse, and vehicle precise query and vehicle fuzzy query are performed.

Data Warehouse Service how to import data in CSV format to a DWS cluster using an OBS foreign table.

Establish an HDFS external table to enable DWS remote access or read MRS Hive data sources.

Data Warehouse Service implements column-level and row-level desensitization of user data to ensure the security and controllability of privacy data.

Using Postman to Call the API for Creating a Cluster.