Types of S3 data retrieval methods


Solution to retrieve a subset of object data rather than the entire object

S3 Select

With S3 Select, you perform data analysis across S3 objects (and other datasets in AWS) using a ready-to-use query-in-place service.

S3 Select can also improve query performance by up to 400% by retrieving a subset of object data rather than the entire object.

Redshift Spectrum

Redshift Spectrum makes it possible to run advanced queries on files located on Amazon Simple Storage Service (S3) without loading them into Redshift or making any special preparations.

This is incorrect because it does not perform an analysis that retrieves a subset of the object data rather than the entire object.

In addition, Redshift Spectrum is primarily intended to be used as a big data solution for storing and analyzing big data in S3


Amazon Athena

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL.

Athena is another tool that can perform SQL analysis on S3 data, but it is used for more advanced analysis than S3 Select, including the ability to perform complex queries and machine learning inferences.


Amazon CloudSearch

Managed service in the AWS Cloud that allows you to easily and cost-effectively configure, manage, and scale a search solution for your website or application