change snapshot field type to text