Expect foreign keys in a column to exist in another specified column.
expect_foreign_keys_in_column_a_to_exist_in_column_b
This expectation level is EXPERIMENTAL
Contributors:
@robertparkerTags:
Metrics:
Description
Expect foreign keys in a column to exist in another specified column.
Ensure that values in the column of interest (ColumnA) are in a valueset provided as a dataframe (df parameter) + column (column_B parameter) or as a list of elements supported by pandas.DataFrame() (e.g. list of dicts [{"col_name": value},], list of tuples [(value, value), (value, value)]. This is a very experimental implementation to describe the functionality, but this expectation should be revisited once cross-table expectation templates are available.
Want to make your own Expectation or an improvement to this one?
We've put together some great how to guides (including videos) on how to create your own expectations in a flash!
You can see those resources here: Contributor Resources
