generation snowflake view 2