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