Help Center/ Data Warehouse Service / More Documents/ Tool Guide (Kuala Lumpur Region)/ DataCheck/ Configuring DataCheck/ Configuration of check_input.xlsx
Updated on 2025-10-14 GMT+08:00
View PDF
Share

Configuration of check_input.xlsx

The check_input.xlsx file includes user input details such as schema, original table name, destination table name, specified column name (all columns are checked by default), check scope, check level (low by default), and excluded columns. You can customize this information as needed.

Perform the following steps to configure the parameters:

  1. Open the check_input.xlsx file in the folder.
  2. Change the values of parameters in the check_input.xlsx file based on the site requirements.

    For the description of the parameters in the check_input.xlsx file, see Table 1.
    • Parameter values are case-insensitive.
    • Do not modify any other parameter except the listed ones.

  3. Save the configuration and exit.
Table 1 Parameters in the check_input.xlsx file

Parameter

Description

Value Range

Default Value

Example

Source Database Name

Name of the database to which the source table to be verified belongs. This parameter is optional. If this parameter is not specified, src.dbname in dbinfo.properties is used.

N/A

N/A

mydb

Source Schema Name

Name of the schema to which the source table to be verified belongs. If this parameter is not involved, leave it blank.

N/A

N/A

myschema

Source Table Name

Name of the table to be verified in the source database. This parameter is mandatory.

N/A

N/A

order_info

Target Database Name

Name of the database to which the destination DWS table belongs. This parameter is optional. If this parameter is not specified, dws.dbname in dbinfo.properties is used.

N/A

N/A

dws_db

Target Schema Name

Name of the schema to which the destination DWS table belongs. This parameter is mandatory.

N/A

N/A

dws_sch

Target Table Name

Name of the table to be verified in the destination DWS database. This parameter is mandatory.

N/A

N/A

dws_info

Check Mode

Check mode. The options are as follows: Statistical value check, precise check, and metadata check.
  • Statistics
  • Preciseness
  • Metadata
  • Statistics

Statistics

Src Row Range(Where sql)

Check scope of table records in the source database. By default, all records are checked.

N/A

ALL

where begin_time > '2020-1-1' and begin_time < '2021-1-1'

DWS Row Range(Where sql)

Check scope of table records in the destination database DWS. By default, all records are checked.

N/A

ALL

where begin_time > '2020-1-1' and begin_time < '2021-1-1'

Column Range

Column check. By default, all supported fields are checked, including numeric, time, and character types. This parameter is optional.

N/A

N/A

col1,col10,col19

Check Strategy

Data check level
  • low
  • middle
  • high

low

low

Sort Column

Optional. During precise verification, data is sorted based on Sort Column. If Sort Column is empty, data is sorted based on the primary key and then compared row by row.

N/A

N/A

col1,col10,col19

Column Exclude

Optional. It is used to exclude specified columns from a check.

N/A

N/A

col1,col10,col19

Columns Wthout Sum

Optional. It is used to exclude specified columns from the SUM check.

N/A

N/A

col1,col10,col19
Parent topic: Configuring DataCheck