Hello!
I have a SQL query that merges data from a staging table to a destination table and I have a handful of test cases that I would like to use to validate if the merge query should insert those records from the staging table or not.
e.g. one test case would be, given a staging table with 1 record, a final table, and the merge statement, should the data from the staging table be inserted into the destination table.
Is there an expectation that exists for this sort of validation?