Latest Posts

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

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...

#1 news story on espn.com details something that happened on SportsCollectors.Net

In my 20's, I taught myself to code and I created what has become a fairly popular community for sports autograph collectors - SportsCollectors.Net. I have mentioned it a few...

Simulating Vertica's conditional_change_event

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...

Snowflake's lateral flatten function on variant data type

Snowflake is a really interesting new data warehouse built on top of AWS. I like their architecture because they had the interesting idea to separate data storage (backed by small...

Creating a Custom Jenkins Plugin with JRuby

I have seen scenarios where I would like to not have Jenkins not execute builds under certain circumstances. One common example is with the Maven Project Plugin, it will often update...

Measuring, Understanding, and Predicting Subscriber Value

The subscription business model is a business model where a customer must pay a subscription price to have access to the product/service. Below are some examples of some popular commercial subscription offerings:...