Expect Slowly changing table type II to have no gaps between the 'end date' of each row, and the next 'start date' in the next row.
expect_queried_slowly_changing_table_to_have_no_gaps
This expectation level is BETA
@itaiseDescription
Expect Slowly changing table type II to have no gaps between the 'end date' of each row, and the next 'start date' in the next row.
Args:
- template_dict: dict with the following keys: primary_key (primary key column name or multiple columns, comma separated), open_date_column (name of the column representing open date), close_date_column (name of the column representing clode date)
- threshold: an optional parameter - default is zero. if the ratio of "gaps" to total table rows is higher than threshold - error will be raised.
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
