GaussDB(DWS) Access

The following figure shows how to use GaussDB(DWS).

Figure 1 Process for using GaussDB(DWS)
Click to enlarge

Accessing a Cluster

GaussDB(DWS) provides a web-based management console and HTTPS-compliant APIs for you to manage data warehouse clusters.

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

Accessing the Database in a Cluster

GaussDB(DWS) supports database access using the following methods:

GaussDB(DWS) clients
Use the GaussDB(DWS) client to access the database in the cluster. For details, see Using the gsql Client to Connect to a Cluster, Using the Data Studio GUI Client to Connect to a Cluster and Using DAS to Connect to a Cluster.
JDBC and ODBC API calling
You can call standard APIs, such as JDBC and ODBC, to access databases in clusters.

For details, see sections 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 GaussDB(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 Third-Party Function Library PyGreSQL of Python to Connect to a Cluster.

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