SNAPFLAKE view 3