Skip to main content

Manage checkpoints

Last updated: November 2026

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.

info

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:

  1. Select File > New > Checkpoint from the main menu.

  2. In the New Checkpoint dialog, enter the checkpoint name and select Excel File as the Data Type.

    New Checkpoint dialog for test data

    Click Next.

  3. In the next dialog, click Browse to select from the list of data files defined in Katalon Studio, then click Finish.

    Select a test data file for the checkpoint
  4. 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.

    Checkpoint snapshot preview for test data

    The checkboxes for the data cells indicate whether they will be used when verifying against other states of this data source later.

  5. Save the Checkpoint when you're done.

Create an Excel checkpoint​

To create a checkpoint with an Excel data file, do as follows:

  1. Select File > New > Checkpoint from the main menu.

  2. In the New Checkpoint dialog, enter the checkpoint name and select Excel File as the Data Type.

    New Checkpoint dialog for an Excel file

    Click Next.

  3. In the next dialog, click Browse to select the Excel file. Specify the Excel sheet to be loaded, then click Finish.

    Select an Excel file and sheet for the checkpoint
  4. 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.

    Checkpoint snapshot preview for an Excel file

    The checkboxes for the data cells indicate whether they will be used when verifying against other states of this data source later.

  5. Save the Checkpoint when you're done.

Create a CSV checkpoint​

To create a checkpoint with a CSV data file, do as follows:

  1. Select File > New > Checkpoint from the main menu.

  2. In the New Checkpoint dialog, enter the checkpoint name and select CSV File as the Data Type.

    New Checkpoint dialog for a CSV file

    Click Next.

  3. 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.

    Select a CSV file and separator for the checkpoint
  4. 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.

    Checkpoint snapshot preview for a CSV file

    The checkboxes for the data cells indicate whether they will be used when verifying against other states of this data source later.

  5. Save the Checkpoint when you're done.

Create a Database checkpoint​

To create a checkpoint with a database data file, do as follows:

  1. Select File > New > Checkpoint from the main menu.

  2. In the New Checkpoint dialog, enter the checkpoint name and select Database Data as the Data Type.

    New Checkpoint dialog for database data

    Click Next.

  3. In the next dialog, enter the database connection details and data query, then click Finish.

    Configure the database connection and query for the checkpoint
    note

    If the User and Password are already provided, the system prioritizes using these credentials for authentication. Otherwise, it checks the Connection Properties table for user and password properties.

  4. 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.

    Checkpoint snapshot preview for database data

    The checkboxes for the data cells indicate whether they will be used when verifying against other states of this data source later.

  5. Save the Checkpoint when you're done.

Was this page helpful?