Articles → AWS → S3 Select In AWS
S3 Select In AWS
Purpose
Difference Between S3 Select And Athena
S3 Select | Athena |
---|
S3 Select works on the single object | Athena can query across multiple objects and buckets |
S3 Select supports only three clauses i.e., From, Where, Limit | Athena supports joins and constraints |
S3 Select is used to retrieve a subset of data | Athena is used for business analytics, reporting, and analyzing large volumes of data |
Sample CSV File
Click to Enlarge
Create An S3 Bucket And Upload A CSV File
Click to Enlarge
Click to Enlarge
Query S3 Using The S3 Bucket
Click to Enlarge
Click to Enlarge
Click to Enlarge
Click to Enlarge
Output
Click to Enlarge
Posted By - | Karan Gupta |
|
Posted On - | Thursday, December 8, 2022 |