Skip to main content

Review & Confirm (DQ)

RightSight User Guide  ·  Module 8 of 14

Review & Confirm (Data Quality Rules) v7.6 beta

Review, edit, validate, and activate data quality rules generated by the AI agent or created manually.

Overview

Review & Confirm (DQ) is the primary workspace for reviewing, editing, validating, and activating data quality rules for a specific connection. It handles rules from all sources — AI-generated, manually created, imported, and cloned from the Reusable Rule Repository.

Target Persona: Data Stewards, DQ Engineers.

Prerequisites: AI Rule Agent execution or manual rule creation for at least one connection.

How This Module Helps

This is the quality gate between rule generation and rule execution. Before rules run against your data, they must be reviewed and approved here. This ensures: - AI-generated rules are validated before execution - Rules have correct expressions, severity, and thresholds - Duplicate or conflicting rules are identified and resolved - Only approved rules consume compute resources during DQ jobs

Connects To Relationship
AI Rule Agent AI-generated rules arrive here
Reusable Rule Repository Repository rules can be cloned here
DQ Jobs Active rules are included in jobs
DQ Results Rule execution results
Business Terms Rules can be linked to terms
Method Path
Sidebar Observability → RightSight → Review & Confirm (under Data Quality)
URL /data-quality-review-confirm
From AI Rule Agent /data-quality-review-confirm?connection=<id>&source=ai-agents
Deep link with rule /data-quality-review-confirm?connection=<id>&ruleId=<ruleId>
Wizard Augmented DQ Config → Step 6

Features & Workflows

1. Selecting a Connection

Steps

  1. Click the Connection Selector dropdown.
Connection selector
Figure 1: Connection selector
  1. Select a connection profile.
Connection selected
Figure 2: Connection selected
  1. The rules table loads with rules for the selected connection.

2. Journey Navigation

The visual stepper shows the review workflow:

Journey Navigation stepper
Figure 3: Journey Navigation stepper
Step Description
Overview Dashboard metrics showing rule counts and coverage
Review Rule-by-rule review and editing
Validate Syntax and logic validation
Activate Bulk activation of approved rules

3. Creating a Rule

Steps

  1. Click + Create Rule in the toolbar.

  2. The Create Rule Modal opens.

  3. Fill in the rule definition:

Field Type Required Description
Rule Name Text Yes Descriptive name
Table Dropdown Yes Target table
Column Dropdown No Target column (optional)
DQ Dimension Dropdown Yes Quality dimension
Rule Type Dropdown Yes Expression, Uniqueness, Schema, etc.
Expression Code editor Conditional SQL expression
Severity Dropdown Yes Critical / High / Medium / Low
Business Term Dropdown No Linked term (optional)
  1. Click Save.
What Happens Next
  • The rule appears in the Review Table with status = Pending.
  • The Metrics Dashboard updates with the new rule count.

4. Reviewing and Editing Rules

Inline Editing

  1. Click on any cell in the Review Table to edit in-place.
Inline cell editing
Figure 4: Inline cell editing

  1. Edit rule name, expression, severity, or dimension.

  2. Changes save automatically.

Detail Panel Editing

  1. Click a rule row to expand the detail panel.
Rule detail panel expanded
Figure 5: Rule detail panel expanded
  1. Navigate through tabs:
Tab Description
Details Full rule definition
Expression SQL expression with syntax highlighting
Audit Change history
Comments Discussion thread
  1. Edit fields and click Save.

5. Activating Rules

Single Rule Activation

  1. Click the context menu (⋮) on a rule row.

  2. Select Activate.

  3. The rule status changes to Active.

Bulk Activation

  1. Select multiple rules using checkboxes.

  2. Click Bulk Actions ▾ → Activate Selected.

  3. All selected rules are activated.

What Happens Next
  • Active rules are included in DQ jobs for execution.
  • The Coverage metric in the Metrics Dashboard updates.

6. Deactivating / Deleting Rules

Deactivating

  1. Click ⋮ → Deactivate on a rule.

  2. The rule status changes to Inactive — it will not run in DQ jobs.

Deleting

  1. Click ⋮ → Delete on a rule.

  2. A confirmation dialog appears.

  3. Confirm to permanently remove the rule.

7. Importing Rules

Steps

  1. Click ↑ Import in the toolbar.

  2. Upload a CSV/Excel file with rule definitions.

  3. Preview with the Import Preview Modal — map columns and review.

  4. Confirm import.

8. Using NLP Rule Builder

Steps

  1. Click NLP Builder in the toolbar.

  2. Type a rule description in plain English (e.g., "Customer email should not be null").

  3. AI translates it to a SQL expression.

  4. Preview and click Create to add the rule.

9. Filtering Rules

Primary Filters

Primary filters
Figure 6: Primary filters
Filter Options
Status All / Active / Pending / Inactive / Failed
Search Free-text across rule names and expressions

Secondary Filters

Filter Options
Domain Business domain
Database Database name
Schema Schema name
DQ Dimension Completeness, Accuracy, etc.

Advanced Filters

Click Advanced Filters for additional options:

Filter Options
Source AI / Manual / Imported
Date Range Created/modified date range
Severity Critical / High / Medium / Low
Business Term Any linked term

10. Deduplication Panel

  1. Click Check Duplicates in the toolbar.

  2. The panel identifies duplicate or overlapping rules with similarity scores.

  3. Choose action: Merge, Keep Both, or Delete Duplicate.

11. Execution Readiness Panel

  1. Click Check Readiness before activating rules.

  2. The panel validates:

Check Description
Syntax valid All selected rules have valid SQL
No conflicts No conflicting rules detected
Required fields All required fields are populated
Readiness score Overall readiness percentage
From Review & Confirm (DQ) Navigate To
Rules from AI Agent AI Rule Agent
Rules from Reusable Repository Reusable Rule Repository
Activate rules → create jobs DQ Jobs
Rule execution → results DQ Results
Business terms → glossary Business Terms
Wizard → next step DQ Jobs

Tips & Best Practices

  • Review AI-generated rules promptly — they start as Pending.
  • Use the NLP Rule Builder for quick rule creation without SQL knowledge.
  • Run the Deduplication Panel before bulk activation to avoid redundant checks.
  • Configure alerts on Critical rules to catch issues immediately.
  • Use the Execution Readiness Panel before activating a large batch of rules.
Was this article helpful?