Query Validation Report

This topic gives a detailed report for queries that have been validated based on the specified dataset.

In This Topic:

Query Validation Report (When Data is Available)
Query Validation Report (When Data is not Available)

Query Validation Report (When Data is Available)

This section provides a comprehensive validation report. It contains:

Status: Status of the Validation stage.
Description: A brief description of the stage is displayed.
Total Queries: The total number of queries in the validation stage.
Validated Queries: Number of queries validated along with the status.
Validation Success Rate: Displays the percentage of queries that are validated successfully.
Time Taken for Validation: The time taken for validating the dataset.

Scripts

This topic provides query validation reports of the scripts. The left panel lists all the scripts along with the validation status. The right panel shows information of the selected file. It includes details of the source and target queries, row count match, and the validation status of the tables.

Click on the preferred query to get more information about the query.

The report displays a detailed summary of Cell-by-cell report along with the functions used for the validation.

Query Validation Report (When Data is not Available)

This section provides a comprehensive query validation report. It contains:

Total Queries: The total number of queries involved in the query validation.
Status: Provides status information about the Query Validation stage.
Description: A brief description of the stage is displayed.
Total Transformed Queries: The total number of queries that are transformed.
Unit Tested Queries: Number of queries used for validation.
Non-Unit Tested Queries: Number of queries not validated.
Validation Success Rate: Provide the percentage of queries that are validated successfully.
Time Taken for Validation: The time taken for validation.
Total Mismatched Rows: Number of mismatched rows.

Scripts

This topic provides query validation reports of the scripts. The left panel lists all the scripts along with the validation status. The right panel shows information of the selected script. It includes details of the source and transformed queries, along with the validation status of the queries.

The query validation status provides information about the validation status of the transformed queries. A Matched status indicates that the source and transformed queries are aligned. If the status is other than Matched, then browse through the error obtain more information.

For instance, if you get a data generation issue, then click VIEW ISSUE to know more about the issue.

If Synthetic Data Validation is configured or looping is enabled, the looping mechanism resends any mismatched queries to the Transformation stage for reconversion or retransformation. This process continues until the outputs of the source and transformed queries match or the configured iteration limit is reached. To access detailed information about these retransformed queries, click Download to obtain the Query Validation reports.

The downloaded report folder contains the following files:

PipelineName_report.xlsx: This report provides information about auto generated queries, query validation status, error categories, etc. This report contains the following sheets:
- QLV Summary: Displays all query types with the count of queries under each query validation status, such as Not Applicable, Data Not Generated, Error, Not Matched, Matched, and more.
- QLV Report: Displays all the queries along with their type, auto-generated query, validation status, error category, error message, and other related details.

PipelineName_report_history.xlsx reports: This report provides detailed information for each query across iterations, including original and auto-generated queries, validation status, iteration count, error category, error message, and other related details. Queries that are not matched are looped back to the Transformation stage for reconversion and then revalidated. This process continues until the source and transformed query outputs match or the configured iteration limit is reached.