update test case for snapshot tables