| Report for Validation Step 1 ✗ ASSERTION tbl_match(keys='id', tolerance={'amount': 0.1}, schema='common')tbl_compare (7 rows) → orders (6 rows), aligned by key idDIFFERENT 7 of 9 rows fail (77.8%) match 2changed 1missing 2extra 2duplicate key 2 tolerance: amount schema: common columns 2 of 3 columns compared |
|
| Schema differences | |
|---|---|
| legacy | only in source |
| Column mismatches (1 of 2 columns) | |
| amount | 1 of 3 matched rows differ (33.3%) |
| Changed rows (1 row) | |
| 2 | amount: 20 → 20.5 (+0.5) |
| Missing from target (2 rows) | |
| 3 | amount: 30 region: E legacy: 0 |
| NULL (null key: can't be matched) | amount: 9 region: z legacy: 0 |
| Extra in target (2 rows) | |
| 5 | amount: 50 region: N |
| NULL (null key: can't be matched) | amount: 8 region: q |
| Duplicate keys (1 key) | |
| 6 | source ×2 · target ×1 |