metadata.remove_primary_key(‘person’)
metadata.add_relationship(parent_table_name=‘master’,child_table_name=‘person’,parent_primary_key=‘CONT_ID’,child_foreign_key=‘CONT_ID’)
cleaned_data = poc.drop_unknown_references(metadata=metadata, data=data)
Traceback (most recent call last):
File “/sasdata/python3.8/lib/python3.8/site-packages/sdv/utils/poc.py”, line 42, in drop_unknown_references
metadata.validate_data(data)
File “/sasdata/python3.8/lib/python3.8/site-packages/sdv/metadata/multi_table.py”, line 826, in validate_data
raise InvalidDataError(errors)
sdv.errors.InvalidDataError: The provided data does not match the metadata:
Relationships:
Error: foreign key column ‘CONT_ID’ contains unknown references: (769162789078583302, 273153625548603402, 373450055630721902, 669058145948247803, 819253797098187502, + more). Please use the utility method ‘drop_unknown_references’ to clean the data.
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File “”, line 1, in
File “/sasdata/python3.8/lib/python3.8/site-packages/sdv/utils/poc.py”, line 65, in drop_unknown_references
raise InvalidDataError([
sdv.errors.InvalidDataError: The provided data does not match the metadata:
All references in table ‘person’ are unknown and must be dropped.Try providing different data for this table.