openFDA L1 — Data Quality Validation

Great-Expectations-style gates run on healthcare_analytics.fact_adverse_events (300 real openFDA FAERS reports). Real FAERS adverse-event reports — not synthetic.

✓ Suite passed — load allowed to proceed

	Expectation	Column	Observed	Result
✓	expect_column_values_to_not_be_null	safetyreportid	300/300	Passed
✓	expect_column_values_to_be_unique	safetyreportid	300/300	Passed
✓	expect_column_values_to_not_be_null	primary_drug	300/300	Passed
✓	expect_column_values_to_not_be_null	received_date	300/300	Passed
✓	expect_column_values_in_set [true,false]	is_serious	300/300	Passed
✓	expect_column_values_to_be_between [0,50]	n_drugs	300/300	Passed
✓	expect_column_values_to_be_between [0,200]	n_reactions	300/300	Passed
✓	expect_column_table_row_count_to_equal_300	(table)	300/300	Passed