Select and Glacier Select
Understand how to use Amazon S3 Select and Glacier Select to efficiently query specific parts of large stored objects using SQL expressions. Explore how these features reduce data transfer and processing time by fetching only relevant data from S3 and Glacier archives, making large dataset analytics faster and more cost-effective.
We'll cover the following...
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 ...