S3 provides a durable storage solution and can store objects as large as 5 TBs. Traditionally, we have been accessing objects as a whole, meaning we'll retrieve the entire 5 TB of the object even if we want a small piece of information from it. Amazon S3 offers S3 Select and S3 Glacier Select to allow us to fetch only a subset of information from a large object using simple SQL expressions.

S3 Select

The S3 Select improves the performance drastically and latency by only retrieving the ...