CORE-1858 : Split TABLE and VIEW snapshots

Split TABLE and VIEW snapshots to remove unnecessary conditions in TABLE
snapshot SQL query.