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.
Statements (44)
| Predicate | Object |
|---|---|
| instanceOf |
Amazon S3 feature
ⓘ
cloud storage data retrieval feature ⓘ |
| accessMethod |
AWS CLI
NERFINISHED
ⓘ
AWS SDKs NERFINISHED ⓘ REST API NERFINISHED ⓘ |
| billingModel |
charged per amount of data returned
ⓘ
charged per amount of data scanned ⓘ |
| developedBy | Amazon Web Services NERFINISHED ⓘ |
| documentationURL | https://docs.aws.amazon.com/AmazonS3/latest/dev/selecting-content-from-objects.html ⓘ |
| integratesWith |
AWS Lambda
NERFINISHED
ⓘ
Amazon Athena NERFINISHED ⓘ Amazon EMR NERFINISHED ⓘ Amazon Redshift Spectrum NERFINISHED ⓘ |
| introducedBy | AWS re:Invent announcement (2017) NERFINISHED ⓘ |
| 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 NERFINISHED ⓘ |
| 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
NERFINISHED
ⓘ
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
NERFINISHED
ⓘ
S3 One Zone-IA NERFINISHED ⓘ S3 Standard NERFINISHED ⓘ S3 Standard-IA NERFINISHED ⓘ |
| useCase |
filtering JSON logs in S3
ⓘ
querying large CSV files in S3 ⓘ reading specific columns from Parquet data ⓘ reducing data scanned by analytics applications ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.