Moving our data warehousing from Hive/EMR to Redshift has the potential to speed up our queries and reduce our costs. Here’s how we are implementing our product recommendations system in Redshift.
Monetate's software engineers are passionate about scale and truly usable product. We are pragmatists, open source across our stack, and drive tens of billions of unique experiences each month for our users.
Our team works out of Conshohocken, Pennsylvania (just outside Philly).
We’ve been running Amazon Redshift in production at Monetate for almost a year. Over that time we’ve learned a bit about what slows queries down and have built some useful views that allow insight into the key contributors to query performance. What follows is a quick run through of those queries.
One thing I’ve never liked about Hacker News comments is that you have to click through to a user’s profile page to learn anything about them. I thought it might be helpful to see some of that information attached to the comments themselves, so I whipped up this user script.