add reverse query on SnapshotTable