How Petco transformed its legacy business for the next generation
summary
Petco moves its data warehouse from Netezza to Snowflake on AWS, forked all data into Snowflake within two months and converts 1,000+ stored procedures over a ten-month effort to fully retire the appliance, migrating ~30 TB and ~1,500 users so ad-hoc queries stop timing out. The stack uses Python ETL, S3, Lambda, EC2/RDS/Aurora and Terraform, enabling concurrent scale and faster Monday processing and powering 7500 associates using the Hub plus new personalization and insurance products.
AI-written summary · about
chapters (20)
- 0:00Intro
- 1:44Agenda
- 2:15Analytics at Petco
- 4:22Petcos old architecture
- 7:01Petco nextgen architecture
- 12:48Pets
- 13:48Additional Business Value
- 17:33The Hub
- 19:50Justin
- 21:44Workplace
- 22:33Feedback
- 23:37Market dynamics
- 28:42Care continuum
- 31:02Pet insurance
- 32:52Employee engagement
- 34:47Pet Coach
- 37:37How Petco started with AWS
- 38:47Where Petco is now
- 42:07Why would you do this
- 46:04Lessons learned
related talks
59mHow Siemens & Petco drive enterprise transformation with data & AI
21mPenguin Random House - Our Story: An Evolving Modern Data Stack With Snowflake
53mBusiness transformation through data and ML
18mOur Analytical Data Journey – from Paper to Petabytes
27mHow To Develop & Operate An Agile Cloud Datawarehouse In A Rapidly Changing Multi-ERP Environment
27mModernize Your Data Warehouse
31mFrom Raw Data to Real Impact: Lessons from Real-World Transformations
34mTales of Data Architecture Evolution