S3 Select

E459737

S3 Select is an Amazon S3 feature that lets you retrieve only a subset of data from within objects using SQL-like queries, improving performance and reducing data transfer costs.

All labels observed (2)

Label Occurrences
S3 Glacier Select 1
S3 Select canonical 1

How this entity was disambiguated

Statements (44)

Predicate Object
instanceOf Amazon S3 feature ⓘ
cloud storage data retrieval feature ⓘ
accessMethod AWS CLI ⓘ
AWS SDKs ⓘ
REST API ⓘ
billingModel charged per amount of data returned ⓘ
charged per amount of data scanned ⓘ
developedBy Amazon Web Services ⓘ
documentationURL https://docs.aws.amazon.com/AmazonS3/latest/dev/selecting-content-from-objects.html ⓘ
integratesWith AWS Lambda ⓘ
Amazon Athena ⓘ
Amazon EMR ⓘ
Amazon Redshift Spectrum ⓘ
linked to: Amazon Redshift
introducedBy AWS re:Invent announcement (2017) ⓘ
limitation does not support all SQL functions ⓘ
queries are limited to a single object at a time ⓘ
operatesOn objects stored in Amazon S3 ⓘ
partOf Amazon Simple Storage Service ⓘ
linked to: Amazon S3
primaryBenefit improve query performance on S3 data ⓘ
reduce application-side filtering workload ⓘ
reduce data transfer costs ⓘ
primaryFunction retrieve subset of data from S3 objects ⓘ
securityFeature supports client-side encryption (with limitations) ⓘ
supports server-side encryption ⓘ
serviceType data filtering service ⓘ
data retrieval optimization feature ⓘ
supportsCompression BZIP2 ⓘ
linked to: bzip2

GZIP ⓘ
supportsFeature column projection ⓘ
row filtering ⓘ
server-side filtering of object content ⓘ
simple SQL predicates ⓘ
supportsFormat CSV ⓘ
JSON ⓘ
Parquet ⓘ
supportsQueryLanguage SQL-like expressions ⓘ
supportsStorageClass S3 Glacier Select ⓘ
linked to: S3 Select

S3 One Zone-IA ⓘ
S3 Standard ⓘ
S3 Standard-IA ⓘ
useCase filtering JSON logs in S3 ⓘ
querying large CSV files in S3 ⓘ
reading specific columns from Parquet data ⓘ
reducing data scanned by analytics applications ⓘ

How these facts were elicited

Referenced by (2)

Full triples — surface form annotated when it differs from this entity's canonical label.

Amazon S3 → supportsOperation → S3 Select ⓘ
S3 Select → supportsStorageClass → S3 Glacier Select ⓘ
linked to: S3 Select