'Fast and simple': online retailer Spring scores with Stitch
Five-year-old Spring offers more than 1,500 clothing, lifestyle, and beauty brands for sale through a direct-to-consumer model via the web and mobile devices. Like most retailers, it generates a lot of data from platforms such as Facebook Ads and Amplitude, and needs to replicate that data to its data warehouse.
"We looked at building some of it ourselves, but eventually decided Stitch was reasonably priced and simple to integrate," says John Gold, senior software engineer at Spring. "Mostly it was just a matter of copying keys from our third-party data sources and switching our analytics to read from the new tables. I've been impressed with how fast and simple it is to replicate data in our Amazon Redshift data warehouse."
Gold is pleased with the way things have gone with Stitch. "We save time by not needing to debug issues in our own code, especially when a third party updates their endpoints for exporting data and we're not resilient to those changes. Stitch also allows us to deprecate some old code that we used to manually extract and load data from some third parties, eventually retiring those servers and saving money."
Soon, he says, "We hope to move our PostgreSQL ETL off our of own servers to Stitch, and we're looking into adding some other third-party integrations."
We save time by not needing to debug issues in our own code, especially when a third party updates their endpoints for exporting data.
Senior Software Engineer