LogisticsSourced

Case Study: Amazon's Supply Chain Finance team gains 10x query performance with Dremio

Amazon Case StudySourced & dated by Case Study Desk

Key facts · TL;DR

Company

Amazon

Industry

Logistics

Challenge

Slow queries over billions of rows

Headline result

Amazon's Supply Chain Finance Analytics team achieved 10x query performance and cut setup time by 90% with Dremio.

Key results

10x

Query performance improvement (60s to 4-6s)

90%

Reduction in setup time

60 hrs

Work eliminated per project

The challenge

Amazon's Supply Chain Finance Analytics team managed hundreds of datasets with billions of rows, relying on 20+ materialized views with complex partitioning. Complex queries took over four minutes, and BI tool extracts failed beyond 100 million rows.

The solution

The team deployed Dremio on AWS, using its SQL Runner and Reflections to accelerate queries directly over their data, choosing Dremio over Apache Kylin for faster setup and BI integration.

The results, in context

Query performance improved 10x, dropping from 60 seconds to 4-6 seconds. The team eliminated 60 hours of work per project and reduced setup time by 90%.

Products used

Dremio DremioDremio SQL RunnerDremio Reflections