Accessing DWS

The following figure shows how to use DWS.

Figure 1 Process for using DWS
Click to enlarge

Accessing a Cluster

DWS provides a web-based management console and HTTPS-compliant APIs for you to manage DWS clusters.

In cluster deployment, if a single node is faulty, the abnormal node is automatically skipped when DWS is accessed. However, the cluster performance will be affected.

Accessing the Database in a Cluster

DWS supports database access using the following methods:

DWS visualization tool
Use the web SQL editor to access the database in the cluster. For details, see Using the SQL Editor to Connect to a DWS Cluster.
DWS client
Use the DWS client to access the database in the cluster. For details, see Using the Linux gsql Client to Connect to a Cluster, Using the Data Studio GUI Client to Connect to a Cluster and Using the SQL Editor to Connect to a Cluster.
JDBC and ODBC API calling
You can call standard APIs, such as JDBC and ODBC, to access databases in DWS clusters.

For details, see Using a JDBC Driver to Connect to a Cluster and Using an ODBC Driver to Connect to a Cluster.
psycopg2 and PyGreSQL drivers
After creating a data warehouse cluster, you can use the third-party function library psycopg2 or PyGreSQL to connect to the cluster, and use Python to access DWS and perform various operations on data tables. For details, see Using the Third-Party Function Library psycopg2 of Python to Connect to a Cluster and Using the Python Library PyGreSQL to Connect to a Cluster.

Currently, DWS does not support cross-database access. Schemas can be used to isolate resources. For details, see CREATE SCHEMA.