truncate live snap prior to insert