Skip to main content

Validation using dataset count check rule

You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

Validation using dataset count check rule

In this business validation rule, the record count of the selected dataset must meet the defined record count criteria. Let’s execute a validation scenario using dataset count check rule.

To learn more, let us go through the below procedure:

  • Click the SCENARIO STUDIO module.
  • Hover on the Scenario Builder snippet from the left pane options.
  • Click the Validation option.

Path: SCENARIO STUDIO > Scenario Builder > Validation

  • The user is navigated to a new validation session page in edit mode.
  • From the Data Source tab, let us drag and drop an RDBMS Table icon onto the Validation session page.
  • Double-tap the Read data from Table widget.

  • A Read data from Table pop-up window is displayed.
  • Let’s select Database Type as Redshift from the drop-down list.
  • Select Connection Name as Redshift -QA from the drop-down list.
  • Click the Navigator button.

  • A Navigator slide screen is displayed.
  • Let’s click the customer table from the tpch1 schema to load the table.
  • Click on Select button.

  • The Read data from “tpch1.customer” for data source “Redshift-QA” widget is saved.
  • Click on the Validation Rules tab.

  • Drag and drop the Dataset Count icon onto the validation session page and double tap on it.

  • A Dataset Count pop-up window is displayed.
  • Add Dataset count rule within the Rule Description text field.
  • Here, let’s add the expression as Dataset count should be Equal to 149000.
  • Click on Save button to save the Dataset count widget.

  • Click the Additional Settings tab.

  • Drag and drop an Email icon onto the validation session page.
  • Double-tap the Email Settings widget.

  • An Email Settings pop-up window is displayed.
  • Click the Save button.

  • This action closes the Email Settings widget by saving its data.
  • Click the Execute Now button.

  • The validation scenario is Failed here.
  • Let’s click on the Dataset count rule widget count 150000.

  • A Validation Scenario Exceptions summary session page is displayed.

  • The email validation results are shown in the below screenshot.

Was this article helpful?