[db] populates some snap view_attributes
saved state after discussion with William
removes unused num_connections attribute from TopicProfile