What's New
Function Overview
Product Bulletin
- Product Notice
- Version Support Notes
Service Overview
- GaussDB(DWS) Infographics
- What Is GaussDB(DWS)?
- Data Warehouse Types
- Data Warehouse Flavors
- Advantages
- Application Scenarios
- Functions
- Concepts
- Related Services
- Security
- GaussDB(DWS) Permissions Management
- GaussDB(DWS) Access
- Restrictions
- Service Quotas
- Technical Specifications
- Version Description
Billing
- Billing Overview
- Billing Modes
- Item
- Billing Examples
- Billing Mode Change
- Renewal
  - Overview
  - Manual Renewal
- Bills
- Arrears
- Stopping Billing
- Cost Management
- Billing FAQs
Getting Started
- Checkpoint Vehicle Analysis
- Supply Chain Requirement Analysis of a Company
- Operations Status Analysis of a Retail Department Store
- Creating a Time Series Table
- Best Practices of Hot and Cold Data Management
- Best Practices for Automatic Partition Management
- Creating a Cluster and Connecting to It
- Using CDM to Migrate MySQL Data to the GaussDB(DWS) Cluster
- Using DLI Flink Jobs to Write Kafka Data to GaussDB(DWS) in Real Time
- Basic SQL Operations
- Database Quick Start
- Getting Started with Common Practices
Videos
Management Guide
- Process for Using GaussDB(DWS)
- Preparations
- Creating or Deleting a Cluster
- Cluster Connection
- SQL Editor Development Tool
- Monitoring and Alarms
- Specifications Change and Scaling
- Backup and Disaster Recovery
  - Snapshots
  - Cluster DR
- Intelligent O&M
- Cluster Management
- Data Integration
- Cluster Log Management
- Database User Management
  - Managing Users
  - Managing Roles
- Audit Logs
- Cluster Security Management
- Resource Management
- Data Source Management
- Managing Logical Clusters
Data Migration and Synchronization
- Data Migration to GaussDB(DWS)
- Importing Data
- Full Database Migration
  - Using CDM to Migrate Data to GaussDB(DWS)
  - Using DSC to Migrate SQL Scripts
- Real-time Import
  - Using DRS to Import Data to GaussDB(DWS)
  - Real-time Data Import From Kafka GaussDB(DWS)
- Metadata Migration
  - Using gs_dump and gs_dumpall to Export Metadata
  - Using gs_restore to Import Data
- Exporting Data
- Other Operations
Developer Guide
- 8.1.3 Recommended
- 8.3.0.x
- 8.1.1
- 8.2.0
- Historical Versions
SQL Syntax Reference
- 8.1.3 Recommended
- 8.3.0.x
- 8.2.0
- Historical Versions
3.0 Developer Guide
- Reading Guide
- Introduction to GaussDB(DWS) 3.0
- Support and Constraints
- SQL Syntax Reference
- Function
- System Catalogs
- System Views
- GUC Parameters
- Development Practices
  - Data Reading/Writing Across Logical Clusters
  - Data Lakehouse
    - Accessing HiveMetaStore Across Clusters
Hybrid Data Warehouse
- Introduction to Hybrid Data Warehouse
- Support and Constraints
- Hybrid Data Warehouse Syntax
  - CREATE TABLE
  - INSERT
  - DELETE
  - UPDATE
  - UPSERT
  - MERGE INTO
  - SELECT
  - ALTER TABLE
- Hybrid Data Warehouse Functions
- Hybrid Data Warehouse GUC Parameters
Stream Data Warehouse
- Introduction to Stream Data Warehouse
- Support and Constraints
  - Extension Constraints
  - Data Types Supported by TSFIELD
- Stream Data Warehouse Syntax
- Functions and Expressions
- Stream Data Warehouse GUC Parameters
Performance Tuning
- Overview of Query Performance Optimization
- Query Execution Process
- SQL Execution Plan
- SQL Optimization Guide
- Optimization Cases
- SQL Execution Troubleshooting
- query_band Load Identification
- Common Performance Parameter Optimization Design
Tool Guide
- Overview
- Downloading Related Tools
- gsql
- Data Studio
- GDS
- DSC
- DWS-Connector
- Server Tool
  - gs_dump
  - gs_dumpall
  - gs_restore
  - gds_check
  - gds_install
  - gds_uninstall
  - gds_ctl
Best Practices
- Import and Export
- Data Migration
- Table Optimization Practices
- Advanced Features
- Database Management
- Sample Data Analysis
- Security Management
API Reference
- Before You Start
- API Overview
- Calling APIs
- Getting Started
- API Description
- Application Cases
  - Using Postman to Call the API for Creating a Cluster
  - Using Postman to Call the API for Creating a Snapshot
- Introduction
- Appendix
SDK Reference
- SDK Overview
FAQs
- Top FAQs
- General Problems
- Database Usage
- Cluster Management
- Database Connections
- Data Import and Export
- Account, Password, and Permission
- Database Performance
- Snapshot Backup and Restoration
  1. Why Is Creating an Automated Snapshot So Slow?
  2. Does a DWS Snapshot Have the Same Function as an EVS Snapshot?
- Billing
Troubleshooting
- Database Connections
- JDBC/ODBC
- Data Import and Export
- Database Parameter Modification
- Account/Permission/Password
- Cluster Performance
- Cluster Exceptions
  - The Disk Usage Alarm Is Frequently Generated
- Database Use
Performance White Paper
- Overview
- Test Result
  - TPC-H Single Query Test
  - TPC-DS Single Query Test
- Test Methods
- Appendixes
  - TPC-H Test Sets
  - TPC-DS Test Sets
Technical White Paper
- GaussDB(DWS)
- Platforms and Technical Specifications Supported by GaussDB(DWS)
  - Technical Specifications
- GaussDB(DWS) Core Technologies
- GaussDB(DWS) Tools
  - Client Tools
  - Database Monitoring Tool
- External APIs
Error Code Reference
- 8.2.0 and earlier versions
  - Management Console Error Code
  - Data Warehouse Service Error Codes
- 8.2.1 or later versions
Glossary
More Documents
- User Guide
- API Reference (ME-Abu Dhabi Region)
- Developer Guide (ME-Abu Dhabi Region)
- SQL Syntax Reference (ME-Abu Dhabi Region)
- Tool Guide (ME-Abu Dhabi Region)
- Error Code Reference (ME-Abu Dhabi Region)
  - Management Console Error Code
- User Guide (Paris Region)
- API Reference (Paris Region)
- Developer Guide (Paris Region)
- SQL Syntax Reference (Paris Region)
- Tool Guide (Paris Region)
- Error Code Reference (Paris Region)
  - Management Console Error Code
- User Guide (Kuala Lumpur Region)
- API Reference (Kuala Lumpur Region)
- Developer Guide (Kuala Lumpur Region)
- SQL Syntax Reference (Kuala Lumpur Region)
- Tool Guide (Kuala Lumpur Region)
- Error Code Reference (Kuala Lumpur Region)
  - Management Console Error Code
General Reference
- Glossary
- Service Level Agreement
- White Papers
- Endpoints
- Permissions