A Checksum Test Case helps you compare Measures, KPIs, and Counts between source and target data sources.

You can choose to specify how much variation in percentage is allowed between the source and target values. This is particularly helpful in monitoring checksums when the source data is constantly changing (for example, in production environments).

Create a Checksum Test Case

Before you create a Checksum Test Case, ensure the data source connections for source and target are available.

There are several methods to launch the Checksum Test Case in the ETL Validator. Depending on your convenience, select any one of the following methods:

  • Method 1
    Mouse hover over the plus icon and select Checksum Test Case.
  • Method 2
  1. On the side menu, click TEST CASES.
  2. Click Tests +.
  3. Under Data Comparison Tests, select Checksum Test Case.
  • Method 3
  1. On the side menu, click HOME.
  2. Under Common Tasks, Click Create Tests.
  3. Under Data Comparison Tests, select Checksum Test Case.

Open/Edit a Checksum Test Case

To open/edit a Checksum Test Case,

  1. On the side menu, click TEST CASES.
  2. In the Test Cases tree, select the folder containing the Checksum Test Case.
  3. Click on the name of the Checksum Test Case.
Information You can also open a test case from the TEST RUNS view

Checksum Test Case Details

When you want to create or edit a Checksum Test Case, complete the information in the following pages:


In the Start page, you will complete basic details like name, database and folder.

This page contains the following:


Enter a name for the Checksum Test Case.


Select the test suite where you want to create the test case.


Select the folder where you want to create the test case.


Select the priority to let your team know about the significance of the Test Case. Available priorities are Lowest, Low, Medium, High, and Highest.

Mark as Private

If selected, the user who selected this option and admin users will only be able to work on this test case. If an admin user select this option while creating the test case, normal users can see the test case, but can not open and work on the test case.


Enter a description for the Query Compare Test Case.


Create a label for easy identification of test plan. To create a label, click the Click to add label link, enter a name, and press Enter.


Select a connection for the target database.


Select a connection for the source database.


Select a workschema where temporary tables with test data will be stored.


In this page, you create and execute a query for Source and Target databases. To create a query, simply type in SQL statements or use Query Builder.

This page contains the following.

Query Builder

Allows you to create a query using the data model defined for the database. If there is no data model, you can create one.

Execute Query

Allows you to execute the query and see results.

Execute Count Query

Allows you to view the actual count of result rows. 

Add Parameters

Allows you to add parameters to the query.

Set Timeout

Allows you to set timeout in minutes for the ETL Server to wait before the query produces results.


In this page, you will select the columns and create joins on the columns.

This page contains the following:

Use Copy Command

This option is for fast loading of data into tables, from PostgreSQL database. However, use this option when PostgreSQL database supports UTF8 characters. If you receive any failures due to UTF8 characters after running the test case, disable this option and re-run the test case.

Remap Columns by Name

Selecting this option will display the mappings by column name. 

Remap Columns by Order

Selecting this option will display the mappings by column order.


In the final Run page, you will run the test plan. Before running the test case, read through the settings below once and understand their purpose.

The Run page contains the following:

Truncate Result tables

Selecting this option empties the result tables after the test case is run.


Allows you to run the test case.


Allows you to stop the test case execution.

Run Date

Allows you to select the test case run history.


Allows you to remove the selected test plan run.

Remove All

Allows you to remove the complete test plan run history.


Allows you to refresh the Run page.


© Datagaps. All rights reserved.
Send feedback on this topic to Datagaps Support