← All Reports Dagster Run

Data Quality Report

Dataset: nessie.mvs.reestrtz | Branch: main | Period: All data | 2026-11-17T07:05:47.412828
PASS
95
Total Checks
74
Passed
21
Failed
0
Errors
77.9%
Pass Rate
Status Severity Field Check Total Passed Failed Rate
PASS WARNING person not_null 25035661 25035661 0 100.00%
PASS CRITICAL record_id not_null 25035661 25035661 0 100.00%
PASS CRITICAL __table__ row_count 1 1 0 100.00%
PASS WARNING person text_null 25035661 25035661 0 100.00%
PASS WARNING person allowed_values 25035661 25035661 0 100.00%
INFO INFO reg_addr_koatuu null_distribution 25035661 25035661 0 100.00%
PASS CRITICAL record_id text_null 25035661 25035661 0 100.00%
INFO INFO reg_addr_koatuu distinct_count 23774414 23774414 0 100.00%
INFO INFO oper_code null_distribution 25035661 25035661 0 100.00%
INFO INFO oper_code distinct_count 25035583 25035583 0 100.00%
PASS INFO reg_addr_koatuu text_null 23774414 23774414 0 100.00%
INFO INFO oper_car_condition null_distribution 25035661 25035661 0 100.00%
PASS INFO oper_car_condition text_null 17927923 17927923 0 100.00%
INFO INFO oper_name null_distribution 25035661 25035661 0 100.00%
PASS INFO oper_car_condition allowed_values 17927923 17927923 0 100.00%
INFO INFO oper_name distinct_count 25034284 25034284 0 100.00%
INFO INFO short_oper_name null_distribution 25035661 25035661 0 100.00%
INFO INFO short_oper_name distinct_count 25034284 25034284 0 100.00%
PASS INFO short_oper_name text_null 25034284 25034284 0 100.00%
INFO INFO oper_description null_distribution 25035661 25035661 0 100.00%
PASS INFO oper_description text_null 25034284 25034284 0 100.00%
INFO INFO oper_notes null_distribution 25035661 25035661 0 100.00%
INFO INFO owner_change null_distribution 25035661 25035661 0 100.00%
PASS INFO oper_notes text_null 25034284 25034284 0 100.00%
INFO INFO is_import null_distribution 25035661 25035661 0 100.00%
INFO INFO is_aid null_distribution 25035661 25035661 0 100.00%
INFO INFO is_credit_leasing null_distribution 25035661 25035661 0 100.00%
INFO INFO modification_type null_distribution 25035661 25035661 0 100.00%
PASS INFO modification_type allowed_values 1366496 1366496 0 100.00%
PASS INFO modification_type text_null 1366496 1366496 0 100.00%
PASS INFO oper_name text_null 25034284 25034284 0 100.00%
FAIL INFO entity_type allowed_values 25034284 25034235 49 100.00%
INFO INFO is_wartime null_distribution 25035661 25035661 0 100.00%
INFO INFO document_basis null_distribution 25035661 25035661 0 100.00%
INFO INFO is_digital null_distribution 25035661 25035661 0 100.00%
INFO INFO is_stolen_related null_distribution 25035661 25035661 0 100.00%
INFO INFO entity_type null_distribution 25035661 25035661 0 100.00%
INFO INFO is_insurer null_distribution 25035661 25035661 0 100.00%
PASS INFO document_basis text_null 25034284 25034284 0 100.00%
INFO INFO is_social null_distribution 25035661 25035661 0 100.00%
PASS WARNING d_reg not_null 25035661 25035661 0 100.00%
PASS INFO entity_type text_null 25034284 25034284 0 100.00%
FAIL WARNING dep_code not_null 25035661 25035560 101 100.00%
INFO INFO d_reg distinct_count 25035661 25035661 0 100.00%
PASS WARNING d_reg date_range 25035661 25035661 0 100.00%
INFO INFO dep_code distinct_count 25035560 25035560 0 100.00%
INFO INFO dep null_distribution 25035661 25035661 0 100.00%
PASS WARNING dep_code text_null 25035560 25035560 0 100.00%
PASS WARNING dep_code regex 25035560 25035560 0 100.00%
INFO INFO dep distinct_count 25035559 25035559 0 100.00%
INFO INFO dep_region null_distribution 25035661 25035661 0 100.00%
INFO INFO dep_region distinct_count 25035559 25035559 0 100.00%
PASS INFO dep text_null 25035559 25035559 0 100.00%
INFO INFO dep_city null_distribution 25035661 25035661 0 100.00%
PASS INFO dep_region text_null 25035559 25035559 0 100.00%
INFO INFO dep_city distinct_count 19603203 19603203 0 100.00%
INFO INFO dep_address null_distribution 25035661 25035661 0 100.00%
INFO INFO dep_address_number null_distribution 25035661 25035661 0 100.00%
INFO INFO dep_description null_distribution 25035661 25035661 0 100.00%
PASS INFO dep_city text_null 19603203 19603203 0 100.00%
PASS INFO dep_address text_null 19603203 19603203 0 100.00%
PASS INFO dep_address_number text_null 19459633 19459633 0 100.00%
PASS INFO dep_description text_null 748357 748357 0 100.00%
INFO INFO dep_hours_of_work null_distribution 25035661 25035661 0 100.00%
INFO INFO dep_phones null_distribution 25035661 25035661 0 100.00%
INFO INFO brand null_distribution 25035661 25035661 0 100.00%
PASS INFO dep_hours_of_work text_null 19602696 19602696 0 100.00%
FAIL WARNING brand text_null 25033391 25033369 22 100.00%
PASS INFO dep_phones text_null 18699720 18699720 0 100.00%
INFO INFO brand distinct_count 25033391 25033391 0 100.00%
INFO INFO model null_distribution 25035661 25035661 0 100.00%
INFO INFO model distinct_count 25027317 25027317 0 100.00%
PASS WARNING model text_null 25027317 25027317 0 100.00%
INFO INFO generation array_length 18415751 18415751 0 100.00%
FAIL INFO generation array_empty 18415751 17269456 1146295 93.78%
INFO INFO model_suffix null_distribution 25035661 25035661 0 100.00%
INFO INFO model_suffix distinct_count 5469467 5469467 0 100.00%
FAIL INFO model_suffix text_null 5469467 5469122 345 99.99%
INFO INFO make_year distinct_count 25035652 25035652 0 100.00%
PASS WARNING make_year range 25035652 25035652 0 100.00%
FAIL WARNING make_year not_null 25035661 25035652 9 100.00%
INFO INFO model_year null_distribution 25035661 25035661 0 100.00%
FAIL INFO model_year range 15787556 15623836 163720 98.96%
INFO INFO model_year distinct_count 15787556 15787556 0 100.00%
INFO INFO vin_year_code null_distribution 25035661 25035661 0 100.00%
INFO INFO vin_year_code distinct_count 18341206 18341206 0 100.00%
PASS INFO vin_year_code text_null 18341206 18341206 0 100.00%
PASS WARNING color not_null 25035661 25035661 0 100.00%
PASS WARNING kind not_null 25035661 25035661 0 100.00%
INFO INFO color distinct_count 25035661 25035661 0 100.00%
INFO INFO kind distinct_count 25035661 25035661 0 100.00%
PASS WARNING kind text_null 25035661 25035661 0 100.00%
PASS WARNING color text_null 25035661 25035661 0 100.00%
INFO INFO body null_distribution 25035661 25035661 0 100.00%
INFO INFO body distinct_count 25035656 25035656 0 100.00%
PASS INFO body text_null 25035656 25035656 0 100.00%
INFO INFO possible_body_types array_length 18415751 18415751 0 100.00%
INFO INFO body_subtype null_distribution 25035661 25035661 0 100.00%
PASS INFO body_subtype text_null 1400826 1400826 0 100.00%
PASS INFO possible_body_types array_empty 18415751 18415751 0 100.00%
INFO INFO body_subtype distinct_count 1400826 1400826 0 100.00%
INFO INFO body_modifiers null_distribution 25035661 25035661 0 100.00%
INFO INFO body_modifiers distinct_count 811974 811974 0 100.00%
PASS INFO body_modifiers text_null 811974 811974 0 100.00%
INFO INFO vehicle_class null_distribution 25035661 25035661 0 100.00%
PASS INFO vehicle_class text_null 12506745 12506745 0 100.00%
INFO INFO vehicle_class distinct_count 12506745 12506745 0 100.00%
PASS INFO generation text_null_array 18415751 18415751 0 100.00%
INFO INFO trailer_prefix distinct_count 1177739 1177739 0 100.00%
PASS INFO trailer_prefix text_null 1177739 1177739 0 100.00%
INFO INFO trailer_prefix null_distribution 25035661 25035661 0 100.00%
INFO INFO purpose distinct_count 25035661 25035661 0 100.00%
INFO INFO fuel null_distribution 25035661 25035661 0 100.00%
PASS INFO possible_body_types text_null_array 18415751 18415751 0 100.00%
PASS WARNING purpose not_null 25035661 25035661 0 100.00%
INFO INFO fuel distinct_count 23848513 23848513 0 100.00%
INFO INFO secondary_fuel null_distribution 25035661 25035661 0 100.00%
INFO INFO secondary_fuel distinct_count 4929314 4929314 0 100.00%
PASS INFO secondary_fuel text_null 4929314 4929314 0 100.00%
INFO INFO is_gbo null_distribution 25035661 25035661 0 100.00%
PASS INFO fuel text_null 23848513 23848513 0 100.00%
PASS WARNING purpose text_null 25035661 25035661 0 100.00%
INFO INFO is_hybrid null_distribution 25035661 25035661 0 100.00%
PASS INFO is_gbo range 23854079 23854079 0 100.00%
INFO INFO fuel_notes distinct_count 5459550 5459550 0 100.00%
PASS INFO is_hybrid range 23854079 23854079 0 100.00%
INFO INFO fuel_notes null_distribution 25035661 25035661 0 100.00%
PASS INFO fuel_notes text_null 5459550 5459550 0 100.00%
INFO INFO capacity null_distribution 25035661 25035661 0 100.00%
FAIL INFO possible_fuels array_empty 18415751 18412178 3573 99.98%
INFO INFO possible_fuels array_length 18415751 18415751 0 100.00%
INFO INFO capacity distinct_count 23849600 23849600 0 100.00%
FAIL INFO capacity range 23849600 23849278 322 100.00%
INFO INFO possible_displacements array_length 18415751 18415751 0 100.00%
INFO INFO own_weight null_distribution 25035661 25035661 0 100.00%
FAIL INFO possible_displacements array_empty 18415751 17951095 464656 97.48%
INFO INFO own_weight distinct_count 24944205 24944205 0 100.00%
INFO INFO total_weight null_distribution 25035661 25035661 0 100.00%
FAIL INFO own_weight range 24944205 24921692 22513 99.91%
INFO INFO total_weight distinct_count 25022284 25022284 0 100.00%
PASS INFO possible_displacements array_range 86742007 86742007 0 100.00%
FAIL INFO total_weight range 25022284 25018952 3332 99.99%
INFO INFO payload null_distribution 25035661 25035661 0 100.00%
PASS INFO possible_fuels text_null_array 18415751 18415751 0 100.00%
INFO INFO payload distinct_count 24942033 24942033 0 100.00%
FAIL INFO payload range 24942033 24916357 25676 99.90%
INFO INFO n_reg_new_cyrillic null_distribution 25035661 25035661 0 100.00%
INFO INFO n_reg_latin null_distribution 25035661 25035661 0 100.00%
INFO INFO n_reg_new_cyrillic distinct_count 24287260 24287260 0 100.00%
PASS INFO n_reg_new_cyrillic text_null 24287260 24287260 0 100.00%
INFO INFO has_old_cyrillic null_distribution 25035661 25035661 0 100.00%
PASS INFO n_reg_latin text_null 24283098 24283098 0 100.00%
INFO INFO has_old_cyrillic distinct_count 25035661 25035661 0 100.00%
INFO INFO n_reg_latin distinct_count 24283098 24283098 0 100.00%
FAIL INFO plate_type not_null 25035661 24385807 649854 97.40%
PASS INFO plate_type allowed_values 24385807 24385807 0 100.00%
INFO INFO region_code null_distribution 25035661 25035661 0 100.00%
INFO INFO plate_type distinct_count 24385807 24385807 0 100.00%
PASS INFO plate_type text_null 24385807 24385807 0 100.00%
INFO INFO region_code distinct_count 22697786 22697786 0 100.00%
PASS INFO region_code text_null 22697786 22697786 0 100.00%
PASS INFO validation_error text_null 2333718 2333718 0 100.00%
FAIL INFO is_valid_plate not_null 25035661 24385807 649854 97.40%
INFO INFO validation_error null_distribution 25035661 25035661 0 100.00%
INFO INFO validation_error distinct_count 2333718 2333718 0 100.00%
INFO INFO raw_vin null_distribution 25035661 25035661 0 100.00%
INFO INFO needs_moderation null_distribution 25035661 25035661 0 100.00%
INFO INFO region_name null_distribution 25035661 25035661 0 100.00%
INFO INFO region_name distinct_count 22611489 22611489 0 100.00%
INFO INFO vin null_distribution 25035661 25035661 0 100.00%
PASS INFO raw_vin text_null 18555243 18555243 0 100.00%
INFO INFO raw_vin distinct_count 18555243 18555243 0 100.00%
PASS INFO vin text_null 18555242 18555242 0 100.00%
INFO INFO is_valid_vin null_distribution 25035661 25035661 0 100.00%
INFO INFO vin distinct_count 18555242 18555242 0 100.00%
INFO INFO vin_validation_error null_distribution 25035661 25035661 0 100.00%
PASS INFO vin_validation_error text_null 227860 227860 0 100.00%
INFO INFO vin_validation_error distinct_count 227860 227860 0 100.00%
PASS INFO region_name text_null 22611489 22611489 0 100.00%
INFO INFO vin_length null_distribution 25035661 25035661 0 100.00%
INFO INFO vin_length distinct_count 18555243 18555243 0 100.00%
INFO INFO vin_has_ioq null_distribution 25035661 25035661 0 100.00%
INFO INFO vin_is_17 null_distribution 25035661 25035661 0 100.00%
INFO INFO vin_wmi null_distribution 25035661 25035661 0 100.00%
INFO INFO vin_wmi distinct_count 18341206 18341206 0 100.00%
PASS INFO vin_wmi text_null 18341206 18341206 0 100.00%
INFO INFO vin_wmi_manufacturer null_distribution 25035661 25035661 0 100.00%
INFO INFO vin_wmi_manufacturer distinct_count 17791421 17791421 0 100.00%
INFO INFO vin_wmi_region null_distribution 25035661 25035661 0 100.00%
INFO INFO vin_wmi_known null_distribution 25035661 25035661 0 100.00%
PASS INFO vin_wmi_region text_null 18326714 18326714 0 100.00%
INFO INFO possible_transmissions array_length 18415751 18415751 0 100.00%
INFO INFO vin_wmi_region distinct_count 18326714 18326714 0 100.00%
PASS INFO vin_wmi_manufacturer text_null 17791421 17791421 0 100.00%
INFO INFO possible_drives array_length 18415751 18415751 0 100.00%
FAIL INFO possible_transmissions array_empty 18415751 18240621 175130 99.05%
FAIL INFO possible_drives array_empty 18415751 18316734 99017 99.46%
INFO INFO backfill_confidence null_distribution 25035661 25035661 0 100.00%
PASS INFO backfill_confidence allowed_values 6605817 6605817 0 100.00%
PASS INFO backfill_confidence text_null 6605817 6605817 0 100.00%
PASS INFO backfill_stage allowed_values 6605817 6605817 0 100.00%
PASS INFO backfill_stage text_null 6605817 6605817 0 100.00%
INFO INFO backfill_stage null_distribution 25035661 25035661 0 100.00%
FAIL WARNING own_weight_lt_total_weight custom_sql 24942033 24941119 914 100.00%
FAIL WARNING weight_ratio_too_high custom_sql 24921096 24233931 687165 97.24%
FAIL INFO make_year_vs_model_year custom_sql 15787555 13164769 2622786 83.39%
PASS INFO possible_transmissions text_null_array 18415751 18415751 0 100.00%
FAIL INFO vin_null_before_2021 custom_sql 13085851 6480034 6605817 49.52%
PASS INFO possible_drives text_null_array 18415751 18415751 0 100.00%
PASS WARNING future_make_year custom_sql 25035652 25035652 0 100.00%
PASS WARNING negative_weight custom_sql 25024456 25024456 0 100.00%
Generated by AUTOMOTO DQ Platform | 2026-11-17T07:05:47.412828