| id | status | amount |
|---|---|---|
| AB123456 | ACTIVE | 10 |
| ZZ000001 | INACTIVE | 20.5 |
| A123 | BAD | 30 |
| ACTIVE | ||
| ab123456 | xx | |
| AA999999 | inactive | 999 |
| check_no | rule_type | column | pattern_or_expr | mode | allow_null | flags | total | pass | fail | null | non_null | pass_rate | fail_samples |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | regex | id | ^[A-Z]{2}\d{6}$ | fullmatch | True | 6 | 4 | 2 | 1 | 5 | 66.67% | A123|ab123456 | |
| 2 | regex | status | ^(ACTIVE|INACTIVE)$ | fullmatch | False | 6 | 3 | 3 | 1 | 5 | 50.00% | BAD|inactive | |
| 3 | regex | amount | ^\d+(\.\d+)?$ | fullmatch | True | 6 | 5 | 1 | 1 | 5 | 83.33% | xx |
| id | status | amount | _dq_issue |
|---|---|---|---|
| A123 | BAD | 30 | FAILED: id !~ ^[A-Z]{2}\d{6}$ |
| ab123456 | xx | FAILED: id !~ ^[A-Z]{2}\d{6}$ |