SNAPFLAKE view 1