schema snapshot with detail