fix snapshot table naming, add tests for explicit names