supply cleanup strategy on table creation.
add primary key to snapshot SELECT query.
adjust tests.