You are viewing documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Scenario Studio › Scenario Builder

Enable Rule Recommendation in Bulk Data Validation

Let Data Trust suggest and auto-populate validation rules based on table metadata.

Overview

This guide shows how to enable and apply rule recommendations in Bulk Data Validation. When rule recommendation is enabled, the system scans the selected tables and auto-populates appropriate check rules, reducing manual configuration effort.

Note: Ensure all required connection profiles are configured in the Administration module before building this scenario.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• A BDV scenario has been created with tables selected and metadata retrieved.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Enable Rule Recommendation in Bulk Data Validation

Figure 1: scenario_explorer

This step involves interacting with the scenario_explorer within the Enable Rule Recommendation in Bulk Data Validation workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 2: Bulk Data Validation session page

This step involves interacting with the Bulk Data Validation session page within the Enable Rule Recommendation in Bulk Data Validation workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 3: Object Selection

This step involves interacting with the Object Selection within the Enable Rule Recommendation in Bulk Data Validation workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 4: metadata

Click Get Metadata to automatically retrieve the column structure and data types from the connected data source. Review the retrieved metadata and deselect any columns that are not relevant before proceeding to configure validation rules.

Figure 5: Recommend Rules

This step involves interacting with the Recommend Rules within the Enable Rule Recommendation in Bulk Data Validation workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 6: Rules Recommendation pop-up window

The Rules Recommendation pop-up window dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Figure 7: process of recommending rules

This step involves interacting with the process of recommending rules within the Enable Rule Recommendation in Bulk Data Validation workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 8: Click the Save icon

Click the Save button to persist the current widget or scenario configuration. A confirmation indicator appears on the canvas once the save is successful, and the widget thumbnail updates to reflect the configured state.

Figure 9: Save Bulk Validation Scenario pop-up window

The Save Bulk Validation Scenario pop-up window dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Figure 10: toaster message

This step involves interacting with the toaster message within the Enable Rule Recommendation in Bulk Data Validation workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 11: Summary details

The Summary details page presents the full outcome of the scenario execution including record counts, match rates, and any detected exceptions. Drill into exception records to inspect individual mismatches and use the Export to CSV option to share results with stakeholders.

Figure 12: execution details

This step involves interacting with the execution details within the Enable Rule Recommendation in Bulk Data Validation workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.