Snowflake Testimonial - Rent The Runway: Reinventing Retail with Data Driven Insights

15. March 2018 14:40 by Jay Grossman in   //  Tags: , , ,   //   Comments (0)
In August, I spoke at the Snowflake analytics tour on the topic "Rent The Runway: Reinventing Retail with Data Driven Insights". I was also asked to provide an account of our experiences migrating data warehouse vendors - going from Vertica to Snowflake. Below is the video:  

Simulating Vertica's conditional_change_event

14. September 2017 20:19 by Jay Grossman in   //  Tags: , , , ,   //   Comments (0)
Lately my team has spent a bunch of time migrating our data warehouse from Vertica to Snowflake. While Snowflake has excellent support for analytic functions, Vertica has some functions that no other columnar database supports.  The conditional change event function "assigns an event window number to each row, starting from 0, and increments by 1 when the result of evaluating the argument expression on the current row differs from that on the previous row". CONDITIONAL_CHANGE_EVENT (... [More]

About the author

Jay Grossman

techie / entrepreneur that enjoys:
 1) my kids + awesome wife
 2) building software projects/products
 3) digging for gold in data sets
 4) my various day jobs
 5) rooting for my Boston sports teams:
    New England PatriotsBoston Red SoxBoston CelticsBoston Bruins

Month List