Kevin Wilkie shows off an interesting window function:
Notice that it has the OVER operator, you can order the data, and even partition the data as needed (Not seen in this example)!
But, as usual with Snowflake, there are even more functions we can work with! Sometimes, you just need to know when items are changed. Enter the CONDITIONAL_CHANGE_EVENT windowing function!
Click through for an example of how CONDITIONAL_CHANGE_EVENT() works.