Articles → AWS → S3 Select In AWS

S3 Select In AWS






Purpose







Difference Between S3 Select And Athena


S3 SelectAthena
S3 Select works on the single objectAthena can query across multiple objects and buckets
S3 Select supports only three clauses i.e., From, Where, LimitAthena supports joins and constraints
S3 Select is used to retrieve a subset of dataAthena is used for business analytics, reporting, and analyzing large volumes of data



Sample CSV File




Picture showing the sample CSV file read using S3 select
Click to Enlarge


Create An S3 Bucket And Upload A CSV File




Picture showing the S3 bucket created in AWS console
Click to Enlarge



Picture showing the CSV file uploaded in S3 bucket
Click to Enlarge


Query S3 Using The S3 Bucket




Picture showing the Query with S3 Select menu
Click to Enlarge



Picture showing setting up the input setting for S3 select
Click to Enlarge



Picture showing setting up the output setting for S3 select
Click to Enlarge



Picture showing the Run SQL query button for running the S3 select query
Click to Enlarge


Output


Picture showing the output of S3 Select In AWS
Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Thursday, December 8, 2022

Query/Feedback


Your Email Id
 
Subject
 
Query/FeedbackCharacters remaining 250