Process for Using GaussDB(DWS) Cluster
Accessing a Cluster
GaussDB(DWS) provides a web-based management console and HTTPS-compliant APIs for you to manage data warehouse clusters.
Accessing the Database in a Cluster
GaussDB(DWS) supports database access using the following methods:
GaussDB(DWS) clients
Access the cluster database using GaussDB(DWS) clients. 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 Using a JDBC Driver to Connect to a Database and Using an ODBC Driver to Connect to a Database.
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.
End-to-End Data Analysis Process
GaussDB(DWS) has been seamlessly integrated with other services on Huawei Cloud, helping you rapidly deploy end-to-end data analysis solutions.
The following figure shows the end-to-end data analysis process. Services in use during each process are also displayed.