Expect all values in a specific column to exist in another table's column.
expect_queried_column_values_to_exist_in_second_table_column
This expectation level is EXPERIMENTAL
Description
Expect all values in a specific column to exist in another table's column.
Args:
- template_dict: dict containing the following keys: first_table_column (name of the main table column), second_table_column (name of the column to compare to in the second table), second_table_full_name, condition (additional condition added in the where clause, provide "1=1" if not needed)
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