Basic Functions of DataCheck

Basic Functions

  • Support data check for source databases such as GaussDB(DWS), MySQL, and PostgreSQL, with the destination database being GaussDB(DWS).

  • Check common fields, such as numeric, time, and character types.

  • Support three check levels, including high, middle, and low.

  • Check schemas, table names, and column names.

  • Specify the check scope of records. By default, all records are checked.

  • Support various check methods, including COUNT(*), MAX, MIN, SUM, AVG, and sampling details check.

  • Output the check result and related check details.

Table 1 Data check levels

Check Level

Description

Syntax

No

-

-

Low

Quantity check

Number of records: COUNT(*)

Middle

  • Quantity check

  • Numeric type check

  • Number of records: COUNT(*)

  • Value check: MAX, MIN, SUM, and AVG

High

  • Quantity check

  • Numeric type check

  • Date type check

  • Character type check

  • Number of records: COUNT(*)

  • Value check: MAX, MIN, SUM, and AVG

  • Date check: MAX, MIN

  • Character check: order by limit 1000, which reads the data and checks whether the content is the same.

last updated: 2025-06-16 14:19 UTC - commit: 82f4678e74eea407ac48b56afc78e708dfc73d10