Rule-Based Data Quality — Custom, Transparent, and Traceable
digna Data Validation lets you define and enforce custom, record-level validation rules — tailored to your business or regulatory needs.
How digna Data Validation Works
The module supports checks for exact values, thresholds, ranges, and reference lists for ensuring Quality and Business/Regulatory Compliance.
Validate every single row of data using customizable rules. Check for specific values, ranges, thresholds, null presence, or reference list across any table.
Rules can be created by technical or business users using an intuitive interface. From “invoice_amount must be positive” to “currency_code must be in {EUR, USD}”, you define what “valid” means.
Every rule runs log results, including the number of failed records and exact failures. All validation outcomes are inspectable, exportable, and easy to trace.
Use Case: Validating Invoice Records
Ensure invoices comply with tax laws and internal policies:
Rule Name | Column | Condition | Status | Failed Records |
|---|---|---|---|---|
Amount Must Be Positive | invoice_amount | invoice_amount > 0 | ✅ Passed | 0 |
VAT Code Required | vat_code | vat_code IS NOT NULL | ❌ Failed | 23 |
Max Invoice Limit | invoice_amount | invoice_amount <= 100,000 | ✅ Passed | 0 |
Currency Code Validity | currency_code | currency_code IN ('EUR', 'USD') | ❌ Failed | 8 |
Invoice Date Not Future | Future | invoice_date <= CURRENT_DATE | ✅ Passed | 0 |
Outcome: digna flags 31 non-compliant records (missing VAT codes, invalid currencies) by applying 5 business rules to the invoice table and triggers alerts for immediate action.
