Help Center > > Management Guide> How to Use DWS

How to Use DWS

Updated at: Aug 05, 2020 GMT+08:00

DWS is an online data processing database that uses the public cloud infrastructure to provide scalable, fully-managed, and out-of-the-box analytic database service that frees you from database management and monitoring. It is a native cloud service based on the Huawei converged data warehouse GaussDB, and is fully compatible with the standard ANSI SQL 99 and SQL 2003, as well as the PostgreSQL and Oracle ecosystems. DWS provides competitive solutions for PB-level big data analysis in various industries.

DWS provides an easy-to-use management console, allowing you to quickly create clusters and easily manage data warehouses.

Process of Using DWS

Figure 1 Process of using DWS
Table 1 Process description

Major Process

Subtask

Description

Operation Instruction

Make preparations.

-

Before using HUAWEI CLOUD DWS, register a public cloud account and select an open port on your firewall as the database port of your data warehouse cluster.

Making Preparations

Create a cluster.

-

Create a cluster before using DWS to execute data analysis tasks. A data warehouse cluster contains nodes in the same subnet. These nodes jointly provide services. During cluster creation, the system creates a default database.

Connect to the cluster.

-

After the data warehouse cluster is successfully created, you can use the SQL client tool or a third-party driver such as JDBC or ODBC to connect to the database in the cluster. You can download the SQL client tool and JDBC/ODBC driver on the Connection Management page of the DWS management console.

Connecting to a Cluster

Access the database.

-

After connecting to the cluster, you can create and manage databases, manage users and permissions, import and export data, and query and analyze data.

Data Warehouse Service Database Developer Guide

  

Manage and monitor the cluster.

  

  

Manage the cluster.

You can view the cluster status, modify the cluster configurations, add cluster tags, adjust the cluster size, and restart and delete the cluster.

Managing Clusters

Manage the snapshot.

You can create a snapshot to back up the cluster and use the snapshot to restore the cluster.

Managing Snapshots

Perform O&M and monitoring.

You can learn the running status and performance of the cluster through monitoring, log auditing, event notification, and resource and load management.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel