Data Integrity Testing
Integrity Score
98%
Tables Validated
847
Data Anomalies
23
Last Validation
2h ago
Validation Results
| Validation Type | Status | Last Run | Issues Found | Actions |
|---|---|---|---|---|
| Schema Validation | Passed | 10 minutes ago | 0 |
|
| Referential Integrity | Warnings | 15 minutes ago | 23 |
|
| Data Quality | Passed | 20 minutes ago | 0 |
|
| Duplicate Detection | Running | 5 minutes ago | - |
|
| Data Consistency | Passed | 30 minutes ago | 0 |
|
Validation Summary
90%
Healthy4
Passed1
Warning1
RunningData Quality Checks
Null Value Detection
Check for missing data valuesData Type Validation
Verify data types match schemaRange Validation
Check values within expected rangesFormat Validation
Verify data format complianceBusiness Rules
Custom business logic validationValidation Settings
% failure rate
Recent Data Issues
| Timestamp | Table | Issue Type | Description | Severity | Status | Action |
|---|---|---|---|---|---|---|
| 2024-09-25 10:15 AM | TCURR |
Foreign Key | 23 orphaned records in currency table | Medium | Investigating | |
| 2024-09-25 09:45 AM | CUSTOMER_DATA |
Duplicate | Duplicate customer records removed | Low | Resolved |
|
| 2024-09-25 09:20 AM | TRANSACTION_LOG |
Format | Date format inconsistency detected | Low | Auto-Fixed |
|