Data Quality Report

Dataset: nessie.mvs.reestrtz | Branch: main | Period: All data | 2026-06-24T07:01:56.247303

FAIL

211

Total Checks

Passed

Failed

211

Errors

0.0%

Pass Rate

Critical Failures

not_null on record_id: ERROR - Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /*+ no_reflections */ COUNT(*) AS total, SUM(CASE WHEN "record_id" IS NULL OR CAST("record_id" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
text_null on record_id: ERROR - Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /*+ no_reflections */ COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("record_id" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("record_id" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "record_id" IS NOT NULL
row_count on __table__: ERROR - Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /*+ no_reflections */ COUNT(*) AS total, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"

Status	Severity	Field	Check	Description	Total	Passed	Failed	Rate	Error
ERROR	CRITICAL	record_id	not_null	record_id should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "record_id" IS NULL OR CAST("record_id" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	CRITICAL	record_id	text_null	record_id should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("record_id" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("record_id" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "record_id" IS NOT NULL
ERROR	WARNING	person	not_null	person should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "person" IS NULL OR CAST("person" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	person	text_null	person should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("person" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("person" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "person" IS NOT NULL
ERROR	CRITICAL	__table__	row_count	Table should have >= 23000000 rows	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	reg_addr_koatuu	distinct_count	reg_addr_koatuu distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "reg_addr_koatuu") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "reg_addr_koatuu" IS NOT NULL
ERROR	INFO	reg_addr_koatuu	text_null	reg_addr_koatuu should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("reg_addr_koatuu" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("reg_addr_koatuu" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "reg_addr_koatuu" IS NOT NULL
ERROR	WARNING	person	allowed_values	person should be in allowed set	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "person" NOT IN ('J', 'P') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "person" IS NOT NULL
ERROR	INFO	oper_code	null_distribution	oper_code null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "oper_code" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "oper_code" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	reg_addr_koatuu	null_distribution	reg_addr_koatuu null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "reg_addr_koatuu" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "reg_addr_koatuu" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	oper_code	distinct_count	oper_code distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "oper_code") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "oper_code" IS NOT NULL
ERROR	INFO	oper_name	text_null	oper_name should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("oper_name" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("oper_name" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "oper_name" IS NOT NULL
ERROR	INFO	oper_name	distinct_count	oper_name distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "oper_name") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "oper_name" IS NOT NULL
ERROR	INFO	oper_name	null_distribution	oper_name null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "oper_name" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "oper_name" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	oper_car_condition	null_distribution	oper_car_condition null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "oper_car_condition" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "oper_car_condition" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	short_oper_name	null_distribution	short_oper_name null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "short_oper_name" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "short_oper_name" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	oper_car_condition	text_null	oper_car_condition should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("oper_car_condition" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("oper_car_condition" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "oper_car_condition" IS NOT NULL
ERROR	INFO	oper_description	null_distribution	oper_description null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "oper_description" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "oper_description" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	oper_description	text_null	oper_description should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("oper_description" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("oper_description" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "oper_description" IS NOT NULL
ERROR	INFO	short_oper_name	text_null	short_oper_name should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("short_oper_name" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("short_oper_name" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "short_oper_name" IS NOT NULL
ERROR	INFO	oper_notes	text_null	oper_notes should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("oper_notes" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("oper_notes" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "oper_notes" IS NOT NULL
ERROR	INFO	oper_notes	null_distribution	oper_notes null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "oper_notes" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "oper_notes" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	owner_change	null_distribution	owner_change null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "owner_change" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "owner_change" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	is_import	null_distribution	is_import null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_import" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_import" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	is_aid	null_distribution	is_aid null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_aid" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_aid" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	modification_type	null_distribution	modification_type null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "modification_type" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "modification_type" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	modification_type	text_null	modification_type should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("modification_type" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("modification_type" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "modification_type" IS NOT NULL
ERROR	INFO	is_credit_leasing	null_distribution	is_credit_leasing null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_credit_leasing" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_credit_leasing" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	oper_car_condition	allowed_values	oper_car_condition should be in allowed set	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "oper_car_condition" NOT IN ('new', 'used', 'any', 'None') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "oper_car_condition" IS NOT NULL
ERROR	INFO	document_basis	null_distribution	document_basis null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "document_basis" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "document_basis" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	document_basis	text_null	document_basis should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("document_basis" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("document_basis" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "document_basis" IS NOT NULL
ERROR	INFO	modification_type	allowed_values	modification_type should be in allowed set	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "modification_type" NOT IN ('engine_swap', 'color_change', 'gas_conversion', 'equipment_remove', 'vin_marking', 'body_swap', 'engine_body_swap', 'equipment_install', 'general_mod') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "modification_type" IS NOT NULL
ERROR	INFO	entity_type	null_distribution	entity_type null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "entity_type" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "entity_type" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	entity_type	text_null	entity_type should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("entity_type" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("entity_type" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "entity_type" IS NOT NULL
ERROR	INFO	entity_type	allowed_values	entity_type should be in allowed set	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "entity_type" NOT IN ('individual', 'military', 'diplomatic', 'any', 'legal_entity', 'government') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "entity_type" IS NOT NULL
ERROR	INFO	is_wartime	null_distribution	is_wartime null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_wartime" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_wartime" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	is_digital	null_distribution	is_digital null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_digital" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_digital" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	is_stolen_related	null_distribution	is_stolen_related null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_stolen_related" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_stolen_related" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	is_insurer	null_distribution	is_insurer null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_insurer" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_insurer" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	is_social	null_distribution	is_social null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_social" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_social" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	d_reg	not_null	d_reg should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "d_reg" IS NULL OR CAST("d_reg" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	d_reg	distinct_count	d_reg distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "d_reg") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "d_reg" IS NOT NULL
ERROR	INFO	short_oper_name	distinct_count	short_oper_name distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Failed to execute GET request against 'http://nessie:19120/api/v2/trees/main?fetch=MINIMAL'. SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "short_oper_name") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "short_oper_name" IS NOT NULL
ERROR	WARNING	d_reg	date_range	d_reg should be between 2010-01-01 and today	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN CAST("d_reg" AS DATE) < DATE '2010-01-01' OR CAST("d_reg" AS DATE) > CURRENT_DATE THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "d_reg" IS NOT NULL
ERROR	WARNING	dep_code	not_null	dep_code should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep_code" IS NULL OR CAST("dep_code" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	dep_code	text_null	dep_code should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep_code" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep_code" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_code" IS NOT NULL
ERROR	INFO	dep_code	distinct_count	dep_code distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "dep_code") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_code" IS NOT NULL
ERROR	INFO	dep	distinct_count	dep distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "dep") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep" IS NOT NULL
ERROR	WARNING	dep_code	regex	dep_code should match ^\d+$	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN NOT REGEXP_MATCHES("dep_code", '^\d+$') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_code" IS NOT NULL
ERROR	INFO	dep	null_distribution	dep null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "dep" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	dep	text_null	dep should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep" IS NOT NULL
ERROR	INFO	dep_region	null_distribution	dep_region null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep_region" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "dep_region" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	dep_city	text_null	dep_city should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep_city" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep_city" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_city" IS NOT NULL
ERROR	INFO	dep_region	distinct_count	dep_region distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "dep_region") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_region" IS NOT NULL
ERROR	INFO	dep_region	text_null	dep_region should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep_region" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep_region" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_region" IS NOT NULL
ERROR	INFO	dep_city	null_distribution	dep_city null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep_city" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "dep_city" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	dep_city	distinct_count	dep_city distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "dep_city") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_city" IS NOT NULL
ERROR	INFO	dep_address_number	null_distribution	dep_address_number null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep_address_number" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "dep_address_number" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	dep_address_number	text_null	dep_address_number should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep_address_number" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep_address_number" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_address_number" IS NOT NULL
ERROR	INFO	dep_address	null_distribution	dep_address null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep_address" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "dep_address" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	dep_address	text_null	dep_address should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep_address" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep_address" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_address" IS NOT NULL
ERROR	INFO	dep_description	null_distribution	dep_description null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep_description" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "dep_description" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	dep_description	text_null	dep_description should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep_description" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep_description" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_description" IS NOT NULL
ERROR	INFO	dep_hours_of_work	null_distribution	dep_hours_of_work null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep_hours_of_work" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "dep_hours_of_work" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	dep_phones	text_null	dep_phones should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep_phones" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep_phones" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_phones" IS NOT NULL
ERROR	INFO	dep_hours_of_work	text_null	dep_hours_of_work should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("dep_hours_of_work" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("dep_hours_of_work" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "dep_hours_of_work" IS NOT NULL
ERROR	INFO	dep_phones	null_distribution	dep_phones null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "dep_phones" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "dep_phones" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	brand	text_null	brand should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("brand" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("brand" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "brand" IS NOT NULL
ERROR	INFO	model	null_distribution	model null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "model" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "model" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	brand	null_distribution	brand null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "brand" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "brand" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	brand	distinct_count	brand distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "brand") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "brand" IS NOT NULL
ERROR	WARNING	model	text_null	model should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("model" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("model" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "model" IS NOT NULL
ERROR	INFO	model	distinct_count	model distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "model") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "model" IS NOT NULL
ERROR	INFO	model_suffix	null_distribution	model_suffix null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "model_suffix" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "model_suffix" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	generation	array_empty	generation should not contain empty arrays	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_LENGTH("generation") = 0 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "generation" IS NOT NULL
ERROR	INFO	generation	text_null_array	generation array should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_CONTAINS("generation", 'NULL') OR ARRAY_CONTAINS("generation", 'Null') OR ARRAY_CONTAINS("generation", 'null') OR ARRAY_CONTAINS("generation", 'NONE') OR ARRAY_CONTAINS("generation", 'None') OR ARRAY_CONTAINS("generation", 'none') OR ARRAY_CONTAINS("generation", 'N/A') OR ARRAY_CONTAINS("generation", 'n/a') OR ARRAY_CONTAINS("generation", 'NA') OR ARRAY_CONTAINS("generation", 'NAN') OR ARRAY_CONTAINS("generation", '-') OR ARRAY_CONTAINS("generation", '#N/A') OR ARRAY_CONTAINS("generation", '#NULL!') OR ARRAY_CONTAINS("generation", '') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "generation" IS NOT NULL
ERROR	INFO	generation	array_length	generation array length statistics	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, ROUND(AVG(CAST(ARRAY_LENGTH("generation") AS DOUBLE)), 1) AS avg_len, MIN(ARRAY_LENGTH("generation")) AS min_len, MAX(ARRAY_LENGTH("generation")) AS max_len, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "generation" IS NOT NULL
ERROR	INFO	model_suffix	distinct_count	model_suffix distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "model_suffix") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "model_suffix" IS NOT NULL
ERROR	INFO	make_year	distinct_count	make_year distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "make_year") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "make_year" IS NOT NULL
ERROR	INFO	model_suffix	text_null	model_suffix should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("model_suffix" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("model_suffix" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "model_suffix" IS NOT NULL
ERROR	WARNING	make_year	not_null	make_year should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "make_year" IS NULL OR CAST("make_year" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	make_year	range	make_year should be in range [1900, 2027]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "make_year" < 1900 OR "make_year" > 2027 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "make_year" IS NOT NULL
ERROR	INFO	model_year	distinct_count	model_year distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "model_year") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "model_year" IS NOT NULL
ERROR	INFO	model_year	range	model_year should be in range [1900, 2027]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "model_year" < 1900 OR "model_year" > 2027 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "model_year" IS NOT NULL
ERROR	INFO	vin_year_code	text_null	vin_year_code should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("vin_year_code" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("vin_year_code" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_year_code" IS NOT NULL
ERROR	INFO	vin_year_code	null_distribution	vin_year_code null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_year_code" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_year_code" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	model_year	null_distribution	model_year null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "model_year" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "model_year" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin_year_code	distinct_count	vin_year_code distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "vin_year_code") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_year_code" IS NOT NULL
ERROR	INFO	color	distinct_count	color distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "color") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "color" IS NOT NULL
ERROR	WARNING	color	not_null	color should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "color" IS NULL OR CAST("color" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	color	text_null	color should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("color" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("color" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "color" IS NOT NULL
ERROR	WARNING	kind	not_null	kind should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "kind" IS NULL OR CAST("kind" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	kind	text_null	kind should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("kind" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("kind" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "kind" IS NOT NULL
ERROR	INFO	kind	distinct_count	kind distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "kind") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "kind" IS NOT NULL
ERROR	INFO	body	null_distribution	body null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "body" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "body" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	body	distinct_count	body distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "body") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "body" IS NOT NULL
ERROR	INFO	body	text_null	body should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("body" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("body" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "body" IS NOT NULL
ERROR	INFO	possible_body_types	array_length	possible_body_types array length statistics	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, ROUND(AVG(CAST(ARRAY_LENGTH("possible_body_types") AS DOUBLE)), 1) AS avg_len, MIN(ARRAY_LENGTH("possible_body_types")) AS min_len, MAX(ARRAY_LENGTH("possible_body_types")) AS max_len, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_body_types" IS NOT NULL
ERROR	INFO	body_subtype	text_null	body_subtype should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("body_subtype" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("body_subtype" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "body_subtype" IS NOT NULL
ERROR	INFO	possible_body_types	array_empty	possible_body_types should not contain empty arrays	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_LENGTH("possible_body_types") = 0 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_body_types" IS NOT NULL
ERROR	INFO	body_subtype	null_distribution	body_subtype null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "body_subtype" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "body_subtype" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	possible_body_types	text_null_array	possible_body_types array should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_CONTAINS("possible_body_types", 'NULL') OR ARRAY_CONTAINS("possible_body_types", 'Null') OR ARRAY_CONTAINS("possible_body_types", 'null') OR ARRAY_CONTAINS("possible_body_types", 'NONE') OR ARRAY_CONTAINS("possible_body_types", 'None') OR ARRAY_CONTAINS("possible_body_types", 'none') OR ARRAY_CONTAINS("possible_body_types", 'N/A') OR ARRAY_CONTAINS("possible_body_types", 'n/a') OR ARRAY_CONTAINS("possible_body_types", 'NA') OR ARRAY_CONTAINS("possible_body_types", 'NAN') OR ARRAY_CONTAINS("possible_body_types", '-') OR ARRAY_CONTAINS("possible_body_types", '#N/A') OR ARRAY_CONTAINS("possible_body_types", '#NULL!') OR ARRAY_CONTAINS("possible_body_types", '') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_body_types" IS NOT NULL
ERROR	INFO	body_subtype	distinct_count	body_subtype distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "body_subtype") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "body_subtype" IS NOT NULL
ERROR	INFO	body_modifiers	distinct_count	body_modifiers distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "body_modifiers") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "body_modifiers" IS NOT NULL
ERROR	INFO	body_modifiers	text_null	body_modifiers should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("body_modifiers" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("body_modifiers" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "body_modifiers" IS NOT NULL
ERROR	INFO	body_modifiers	null_distribution	body_modifiers null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "body_modifiers" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "body_modifiers" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vehicle_class	null_distribution	vehicle_class null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vehicle_class" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vehicle_class" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vehicle_class	text_null	vehicle_class should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("vehicle_class" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("vehicle_class" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vehicle_class" IS NOT NULL
ERROR	INFO	trailer_prefix	null_distribution	trailer_prefix null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "trailer_prefix" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "trailer_prefix" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vehicle_class	distinct_count	vehicle_class distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "vehicle_class") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vehicle_class" IS NOT NULL
ERROR	INFO	trailer_prefix	text_null	trailer_prefix should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("trailer_prefix" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("trailer_prefix" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "trailer_prefix" IS NOT NULL
ERROR	INFO	trailer_prefix	distinct_count	trailer_prefix distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "trailer_prefix") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "trailer_prefix" IS NOT NULL
ERROR	INFO	purpose	distinct_count	purpose distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "purpose") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "purpose" IS NOT NULL
ERROR	WARNING	purpose	not_null	purpose should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "purpose" IS NULL OR CAST("purpose" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	purpose	text_null	purpose should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("purpose" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("purpose" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "purpose" IS NOT NULL
ERROR	INFO	fuel	null_distribution	fuel null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "fuel" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "fuel" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	fuel	text_null	fuel should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("fuel" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("fuel" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "fuel" IS NOT NULL
ERROR	INFO	fuel	distinct_count	fuel distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "fuel") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "fuel" IS NOT NULL
ERROR	INFO	secondary_fuel	null_distribution	secondary_fuel null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "secondary_fuel" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "secondary_fuel" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	secondary_fuel	distinct_count	secondary_fuel distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "secondary_fuel") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "secondary_fuel" IS NOT NULL
ERROR	INFO	secondary_fuel	text_null	secondary_fuel should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("secondary_fuel" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("secondary_fuel" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "secondary_fuel" IS NOT NULL
ERROR	INFO	is_gbo	null_distribution	is_gbo null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_gbo" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_gbo" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	is_gbo	range	is_gbo should be in range [0, 1]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_gbo" < 0 OR "is_gbo" > 1 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "is_gbo" IS NOT NULL
ERROR	INFO	is_hybrid	range	is_hybrid should be in range [0, 1]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_hybrid" < 0 OR "is_hybrid" > 1 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "is_hybrid" IS NOT NULL
ERROR	INFO	is_hybrid	null_distribution	is_hybrid null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_hybrid" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_hybrid" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	fuel_notes	text_null	fuel_notes should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("fuel_notes" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("fuel_notes" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "fuel_notes" IS NOT NULL
ERROR	INFO	fuel_notes	null_distribution	fuel_notes null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "fuel_notes" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "fuel_notes" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	fuel_notes	distinct_count	fuel_notes distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "fuel_notes") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "fuel_notes" IS NOT NULL
ERROR	INFO	possible_fuels	array_length	possible_fuels array length statistics	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, ROUND(AVG(CAST(ARRAY_LENGTH("possible_fuels") AS DOUBLE)), 1) AS avg_len, MIN(ARRAY_LENGTH("possible_fuels")) AS min_len, MAX(ARRAY_LENGTH("possible_fuels")) AS max_len, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_fuels" IS NOT NULL
ERROR	INFO	possible_fuels	array_empty	possible_fuels should not contain empty arrays	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_LENGTH("possible_fuels") = 0 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_fuels" IS NOT NULL
ERROR	INFO	capacity	null_distribution	capacity null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "capacity" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "capacity" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	possible_fuels	text_null_array	possible_fuels array should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_CONTAINS("possible_fuels", 'NULL') OR ARRAY_CONTAINS("possible_fuels", 'Null') OR ARRAY_CONTAINS("possible_fuels", 'null') OR ARRAY_CONTAINS("possible_fuels", 'NONE') OR ARRAY_CONTAINS("possible_fuels", 'None') OR ARRAY_CONTAINS("possible_fuels", 'none') OR ARRAY_CONTAINS("possible_fuels", 'N/A') OR ARRAY_CONTAINS("possible_fuels", 'n/a') OR ARRAY_CONTAINS("possible_fuels", 'NA') OR ARRAY_CONTAINS("possible_fuels", 'NAN') OR ARRAY_CONTAINS("possible_fuels", '-') OR ARRAY_CONTAINS("possible_fuels", '#N/A') OR ARRAY_CONTAINS("possible_fuels", '#NULL!') OR ARRAY_CONTAINS("possible_fuels", '') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_fuels" IS NOT NULL
ERROR	INFO	capacity	distinct_count	capacity distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "capacity") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "capacity" IS NOT NULL
ERROR	INFO	capacity	range	capacity should be in range [0, 20000]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "capacity" < 0 OR "capacity" > 20000 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "capacity" IS NOT NULL
ERROR	INFO	possible_displacements	array_range	possible_displacements array elements should be in range [0, 20000]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN elem < 0 OR elem > 20000 THEN 1 ELSE 0 END) AS failed FROM ( SELECT FLATTEN("possible_displacements") AS elem FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_displacements" IS NOT NULL )
ERROR	INFO	possible_displacements	array_empty	possible_displacements should not contain empty arrays	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_LENGTH("possible_displacements") = 0 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_displacements" IS NOT NULL
ERROR	INFO	possible_displacements	array_length	possible_displacements array length statistics	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, ROUND(AVG(CAST(ARRAY_LENGTH("possible_displacements") AS DOUBLE)), 1) AS avg_len, MIN(ARRAY_LENGTH("possible_displacements")) AS min_len, MAX(ARRAY_LENGTH("possible_displacements")) AS max_len, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_displacements" IS NOT NULL
ERROR	INFO	own_weight	null_distribution	own_weight null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "own_weight" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "own_weight" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	own_weight	range	own_weight should be in range [40, 45000]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "own_weight" < 40 OR "own_weight" > 45000 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "own_weight" IS NOT NULL
ERROR	INFO	own_weight	distinct_count	own_weight distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "own_weight") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "own_weight" IS NOT NULL
ERROR	INFO	total_weight	distinct_count	total_weight distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "total_weight") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "total_weight" IS NOT NULL
ERROR	INFO	total_weight	null_distribution	total_weight null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "total_weight" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "total_weight" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	payload	distinct_count	payload distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "payload") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "payload" IS NOT NULL
ERROR	INFO	total_weight	range	total_weight should be in range [60, 90000]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "total_weight" < 60 OR "total_weight" > 90000 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "total_weight" IS NOT NULL
ERROR	INFO	payload	null_distribution	payload null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "payload" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "payload" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	payload	range	payload should be in range [0, 35000]	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "payload" < 0 OR "payload" > 35000 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "payload" IS NOT NULL
ERROR	INFO	n_reg_new_cyrillic	null_distribution	n_reg_new_cyrillic null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "n_reg_new_cyrillic" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "n_reg_new_cyrillic" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	n_reg_new_cyrillic	distinct_count	n_reg_new_cyrillic distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "n_reg_new_cyrillic") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "n_reg_new_cyrillic" IS NOT NULL
ERROR	INFO	n_reg_latin	null_distribution	n_reg_latin null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "n_reg_latin" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "n_reg_latin" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	n_reg_latin	distinct_count	n_reg_latin distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "n_reg_latin") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "n_reg_latin" IS NOT NULL
ERROR	INFO	n_reg_new_cyrillic	text_null	n_reg_new_cyrillic should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("n_reg_new_cyrillic" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("n_reg_new_cyrillic" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "n_reg_new_cyrillic" IS NOT NULL
ERROR	INFO	n_reg_latin	text_null	n_reg_latin should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("n_reg_latin" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("n_reg_latin" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "n_reg_latin" IS NOT NULL
ERROR	INFO	plate_type	text_null	plate_type should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("plate_type" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("plate_type" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "plate_type" IS NOT NULL
ERROR	INFO	has_old_cyrillic	distinct_count	has_old_cyrillic distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "has_old_cyrillic") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "has_old_cyrillic" IS NOT NULL
ERROR	INFO	plate_type	not_null	plate_type should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "plate_type" IS NULL OR CAST("plate_type" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	has_old_cyrillic	null_distribution	has_old_cyrillic null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "has_old_cyrillic" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "has_old_cyrillic" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	plate_type	distinct_count	plate_type distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "plate_type") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "plate_type" IS NOT NULL
ERROR	INFO	plate_type	allowed_values	plate_type should be in allowed set	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "plate_type" NOT IN ('UA_MODERN', 'UA_ONLINE', 'NON_STANDARD', 'UA_1992', 'UA_1995', 'UA_EV') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "plate_type" IS NOT NULL
ERROR	INFO	is_valid_plate	not_null	is_valid_plate should not be null or empty	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_valid_plate" IS NULL OR CAST("is_valid_plate" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	region_code	null_distribution	region_code null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "region_code" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "region_code" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	region_code	distinct_count	region_code distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "region_code") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "region_code" IS NOT NULL
ERROR	INFO	region_code	text_null	region_code should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("region_code" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("region_code" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "region_code" IS NOT NULL
ERROR	INFO	validation_error	distinct_count	validation_error distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "validation_error") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "validation_error" IS NOT NULL
ERROR	INFO	region_name	text_null	region_name should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("region_name" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("region_name" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "region_name" IS NOT NULL
ERROR	INFO	region_name	null_distribution	region_name null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "region_name" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "region_name" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	validation_error	null_distribution	validation_error null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "validation_error" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "validation_error" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	validation_error	text_null	validation_error should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("validation_error" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("validation_error" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "validation_error" IS NOT NULL
ERROR	INFO	region_name	distinct_count	region_name distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "region_name") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "region_name" IS NOT NULL
ERROR	INFO	raw_vin	distinct_count	raw_vin distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "raw_vin") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "raw_vin" IS NOT NULL
ERROR	INFO	needs_moderation	null_distribution	needs_moderation null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "needs_moderation" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "needs_moderation" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	raw_vin	null_distribution	raw_vin null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "raw_vin" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "raw_vin" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	raw_vin	text_null	raw_vin should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("raw_vin" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("raw_vin" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "raw_vin" IS NOT NULL
ERROR	INFO	vin	distinct_count	vin distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "vin") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin" IS NOT NULL
ERROR	INFO	vin	null_distribution	vin null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin	text_null	vin should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("vin" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("vin" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin" IS NOT NULL
ERROR	INFO	vin_validation_error	null_distribution	vin_validation_error null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_validation_error" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_validation_error" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	is_valid_vin	null_distribution	is_valid_vin null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "is_valid_vin" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "is_valid_vin" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin_length	distinct_count	vin_length distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "vin_length") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_length" IS NOT NULL
ERROR	INFO	vin_validation_error	distinct_count	vin_validation_error distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "vin_validation_error") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_validation_error" IS NOT NULL
ERROR	INFO	vin_validation_error	text_null	vin_validation_error should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("vin_validation_error" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("vin_validation_error" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_validation_error" IS NOT NULL
ERROR	INFO	vin_is_17	null_distribution	vin_is_17 null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_is_17" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_is_17" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin_length	null_distribution	vin_length null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_length" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_length" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin_wmi	text_null	vin_wmi should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("vin_wmi" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("vin_wmi" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_wmi" IS NOT NULL
ERROR	INFO	vin_wmi	distinct_count	vin_wmi distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "vin_wmi") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_wmi" IS NOT NULL
ERROR	INFO	vin_has_ioq	null_distribution	vin_has_ioq null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_has_ioq" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_has_ioq" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin_wmi	null_distribution	vin_wmi null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_wmi" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_wmi" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin_wmi_manufacturer	null_distribution	vin_wmi_manufacturer null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_wmi_manufacturer" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_wmi_manufacturer" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin_wmi_manufacturer	distinct_count	vin_wmi_manufacturer distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "vin_wmi_manufacturer") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_wmi_manufacturer" IS NOT NULL
ERROR	INFO	vin_wmi_region	distinct_count	vin_wmi_region distinct value count	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, COUNT(DISTINCT "vin_wmi_region") AS distinct_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_wmi_region" IS NOT NULL
ERROR	INFO	vin_wmi_region	null_distribution	vin_wmi_region null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_wmi_region" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_wmi_region" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	vin_wmi_manufacturer	text_null	vin_wmi_manufacturer should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("vin_wmi_manufacturer" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("vin_wmi_manufacturer" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_wmi_manufacturer" IS NOT NULL
ERROR	INFO	vin_wmi_region	text_null	vin_wmi_region should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("vin_wmi_region" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("vin_wmi_region" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "vin_wmi_region" IS NOT NULL
ERROR	INFO	possible_transmissions	array_length	possible_transmissions array length statistics	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, ROUND(AVG(CAST(ARRAY_LENGTH("possible_transmissions") AS DOUBLE)), 1) AS avg_len, MIN(ARRAY_LENGTH("possible_transmissions")) AS min_len, MAX(ARRAY_LENGTH("possible_transmissions")) AS max_len, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_transmissions" IS NOT NULL
ERROR	INFO	possible_drives	array_length	possible_drives array length statistics	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, ROUND(AVG(CAST(ARRAY_LENGTH("possible_drives") AS DOUBLE)), 1) AS avg_len, MIN(ARRAY_LENGTH("possible_drives")) AS min_len, MAX(ARRAY_LENGTH("possible_drives")) AS max_len, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_drives" IS NOT NULL
ERROR	INFO	vin_wmi_known	null_distribution	vin_wmi_known null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin_wmi_known" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "vin_wmi_known" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	possible_transmissions	array_empty	possible_transmissions should not contain empty arrays	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_LENGTH("possible_transmissions") = 0 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_transmissions" IS NOT NULL
ERROR	INFO	possible_transmissions	text_null_array	possible_transmissions array should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_CONTAINS("possible_transmissions", 'NULL') OR ARRAY_CONTAINS("possible_transmissions", 'Null') OR ARRAY_CONTAINS("possible_transmissions", 'null') OR ARRAY_CONTAINS("possible_transmissions", 'NONE') OR ARRAY_CONTAINS("possible_transmissions", 'None') OR ARRAY_CONTAINS("possible_transmissions", 'none') OR ARRAY_CONTAINS("possible_transmissions", 'N/A') OR ARRAY_CONTAINS("possible_transmissions", 'n/a') OR ARRAY_CONTAINS("possible_transmissions", 'NA') OR ARRAY_CONTAINS("possible_transmissions", 'NAN') OR ARRAY_CONTAINS("possible_transmissions", '-') OR ARRAY_CONTAINS("possible_transmissions", '#N/A') OR ARRAY_CONTAINS("possible_transmissions", '#NULL!') OR ARRAY_CONTAINS("possible_transmissions", '') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_transmissions" IS NOT NULL
ERROR	INFO	backfill_confidence	text_null	backfill_confidence should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("backfill_confidence" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("backfill_confidence" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "backfill_confidence" IS NOT NULL
ERROR	INFO	backfill_confidence	allowed_values	backfill_confidence should be in allowed set	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "backfill_confidence" NOT IN ('LOW', 'MEDIUM', 'HIGH') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "backfill_confidence" IS NOT NULL
ERROR	INFO	backfill_confidence	null_distribution	backfill_confidence null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "backfill_confidence" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "backfill_confidence" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	INFO	possible_drives	array_empty	possible_drives should not contain empty arrays	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_LENGTH("possible_drives") = 0 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_drives" IS NOT NULL
ERROR	INFO	possible_drives	text_null_array	possible_drives array should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ARRAY_CONTAINS("possible_drives", 'NULL') OR ARRAY_CONTAINS("possible_drives", 'Null') OR ARRAY_CONTAINS("possible_drives", 'null') OR ARRAY_CONTAINS("possible_drives", 'NONE') OR ARRAY_CONTAINS("possible_drives", 'None') OR ARRAY_CONTAINS("possible_drives", 'none') OR ARRAY_CONTAINS("possible_drives", 'N/A') OR ARRAY_CONTAINS("possible_drives", 'n/a') OR ARRAY_CONTAINS("possible_drives", 'NA') OR ARRAY_CONTAINS("possible_drives", 'NAN') OR ARRAY_CONTAINS("possible_drives", '-') OR ARRAY_CONTAINS("possible_drives", '#N/A') OR ARRAY_CONTAINS("possible_drives", '#NULL!') OR ARRAY_CONTAINS("possible_drives", '') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "possible_drives" IS NOT NULL
ERROR	INFO	backfill_stage	text_null	backfill_stage should not contain text representations of NULL	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN UPPER(CAST("backfill_stage" AS VARCHAR)) IN ('NULL', 'NONE', 'N/A', 'NA', 'NAN', '-', '#N/A', '#NULL!') OR CAST("backfill_stage" AS VARCHAR) = '' THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "backfill_stage" IS NOT NULL
ERROR	INFO	backfill_stage	null_distribution	backfill_stage null vs non-null distribution	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "backfill_stage" IS NULL THEN 1 ELSE 0 END) AS null_count, SUM(CASE WHEN "backfill_stage" IS NOT NULL THEN 1 ELSE 0 END) AS not_null_count, 0 AS failed FROM nessie.mvs.reestrtz AT BRANCH "main"
ERROR	WARNING	weight_ratio_too_high	custom_sql	total_weight / own_weight не має перевищувати 4	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN CAST("total_weight" AS DOUBLE) / CAST("own_weight" AS DOUBLE) > 4 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "own_weight" IS NOT NULL AND "total_weight" IS NOT NULL AND "own_weight" > 0
ERROR	WARNING	own_weight_lt_total_weight	custom_sql	own_weight має бути менший за total_weight	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "own_weight" > "total_weight" THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "own_weight" IS NOT NULL AND "total_weight" IS NOT NULL
ERROR	INFO	backfill_stage	allowed_values	backfill_stage should be in allowed set	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "backfill_stage" NOT IN ('stg1_operations', 'stg2_mtsbu_mvs', 'stg3_mtsbu_policies', 'stg4_old_mvs', 'stg5_propagation') THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "backfill_stage" IS NOT NULL
ERROR	WARNING	negative_weight	custom_sql	Від'ємна вага (own_weight або total_weight < 0)	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "own_weight" < 0 OR "total_weight" < 0 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "own_weight" IS NOT NULL OR "total_weight" IS NOT NULL
ERROR	INFO	make_year_vs_model_year	custom_sql	model_year (з VIN) не має відрізнятись від make_year більш ніж на 2 роки	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN ABS("make_year" - "model_year") > 2 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "model_year" IS NOT NULL AND "make_year" IS NOT NULL
ERROR	WARNING	future_make_year	custom_sql	Автомобілі з майбутнього (make_year > поточний рік + 1)	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "make_year" > EXTRACT(YEAR FROM CURRENT_DATE) + 1 THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "make_year" IS NOT NULL
ERROR	INFO	vin_null_before_2021	custom_sql	VIN має бути NULL для реєстрацій до 2021-01-01	-	-	-	-	Flight returned invalid argument error, with message: Table 'nessie.mvs.reestrtz' not found SQL Query SELECT /+ no_reflections / COUNT(*) AS total, SUM(CASE WHEN "vin" IS NOT NULL THEN 1 ELSE 0 END) AS failed FROM nessie.mvs.reestrtz AT BRANCH "main" WHERE "d_reg" < '2021-01-01'

Generated by AUTOMOTO DQ Platform | 2026-06-24T07:01:56.247303