Matillion ETL for Amazon Redshift Case Study | Thrive Market

  • Richard Thelwell
  • May 18, 2016

Watch this short video case study to find out how Matillion ETL for Amazon Redshift user, Thrive Market, transformed their data warehousing strategy with the help of Matillion and the AWS Cloud.

Thrive Market have grown from a zero sized business to over $100 million run rate in just 14 months and with that growth, their data volumes have expanded on a massive scale.

The company needed a data warehousing solution that could cope with their data demands, and scale with the growth of their business. This led to them choosing AWS, Amazon Redshift and Matillion ETL for Amazon Redshift.

In this video we hear more from the team at Thrive Market on why they chose AWS and Matillion ETL for Amazon Redshift.

About Thrive Market

Thrive Market is a subscription based e-commerce platform aiming to make high quality, natural and organic products available for families throughout America.

Thrive Market members pay an annual membership fee of just $60 and in return get access to a large selection of healthy snacks, supplements, home, beauty and baby products at between 30-50% off their retail prices.

thrive market logo products

As part of their initiative to improve the lives of families throughout America, Thrive Market donates an annual membership to a family in need, every time a membership is bought.

Based in Los Angeles, the company is one of the fastest growing start-ups in America, reaching an annualised run rate of over $100 million, just over a year after their initial launch. This growth has continued at a staggering pace with over 200,000 paying members signed up already.

How Matillion have helped

In the past Thrive Market used Microsoft technology to load their enterprise data warehouse environment. That specific load would take over 5 hours to complete.

In contrast, VP of Data Strategy & Analytics, Lobsang Moreno says that “by using Matillion we can load up the data warehouse every 30 mins and it takes about 5 minutes to run”.

The combination between Redshift and Matillion has allowed us to play in the Big Data environment where we’re moving over 10 million records an hour Lobsang Moreno, VP Data Strategy & Analytics, Thrive Market

Thrive Market collect data from a whole host of sources and locations. With the use of Matillion ETL for Amazon Redshift and Amazon Redshift database they have been able to aggregate all of that data from all of their sources to, “create a 360 degree view of the customer”.