Manage checkpoints
Checkpoint is the snapshot of test data taken at a specific time. A checkpoint is used to verify whether the current state of the data source is different from its previous state.
You can use checkpoints in database validation cases where values change constantly by comparing a data snapshot with the data source's later state. For more details, refer to the [Common] Verify Checkpoint keyword.
This document shows you how to create checkpoints from test data files supported by Katalon Studio.
Starting with Katalon Studio 11.7.0, data-driven test execution requires a paid plan. See pricing page.
Create a checkpoint from Test Data​
You can create a checkpoint from test data files that have been defined in Katalon Studio. Do as follows:
-
Select File > New > Checkpoint from the main menu.
-
In the New Checkpoint dialog, enter the checkpoint name and select Excel File as the Data Type.
Click Next.
-
In the next dialog, click Browse to select from the list of data files defined in Katalon Studio, then click Finish.
-
Click Take Snapshot to take a snapshot of the test data. The state of the selected data source is captured and displayed in the preview section.
The checkboxes for the data cells indicate whether they will be used when verifying against other states of this data source later.
-
Save the Checkpoint when you're done.
Create an Excel checkpoint​
To create a checkpoint with an Excel data file, do as follows:
-
Select File > New > Checkpoint from the main menu.
-
In the New Checkpoint dialog, enter the checkpoint name and select Excel File as the Data Type.
Click Next.
-
In the next dialog, click Browse to select the Excel file. Specify the Excel sheet to be loaded, then click Finish.
-
Click Take Snapshot to take a snapshot of the test data. The state of the selected data source is captured and displayed in the preview section.
The checkboxes for the data cells indicate whether they will be used when verifying against other states of this data source later.
-
Save the Checkpoint when you're done.
Create a CSV checkpoint​
To create a checkpoint with a CSV data file, do as follows:
-
Select File > New > Checkpoint from the main menu.
-
In the New Checkpoint dialog, enter the checkpoint name and select CSV File as the Data Type.
Click Next.
-
In the next dialog, click Browse to select the CSV file. Specify the character to use as the separator for the CSV file, then click Finish.
-
Click Take Snapshot to take a snapshot of the test data. The state of the selected data source is captured and displayed in the preview section.
The checkboxes for the data cells indicate whether they will be used when verifying against other states of this data source later.
-
Save the Checkpoint when you're done.
Create a Database checkpoint​
To create a checkpoint with a database data file, do as follows:
-
Select File > New > Checkpoint from the main menu.
-
In the New Checkpoint dialog, enter the checkpoint name and select Database Data as the Data Type.
Click Next.
-
In the next dialog, enter the database connection details and data query, then click Finish.
noteIf the User and Password are already provided, the system prioritizes using these credentials for authentication. Otherwise, it checks the Connection Properties table for
userandpasswordproperties. -
Click Take Snapshot to take a snapshot of the test data. The state of the selected data source is captured and displayed in the preview section.
The checkboxes for the data cells indicate whether they will be used when verifying against other states of this data source later.
-
Save the Checkpoint when you're done.