S3 Select

Nov 5, 2022

• Aws
• S3
• SQL

• AWS Wiki
• S3
• Athena

• Amazon S3 Select is designed to help analyze and process data within an object in Amazon S3 buckets, faster and cheaper. It works by providing the ability to retrieve a subset of data from an object in Amazon S3 using simple SQL expressions. Your applications no longer have to use compute resource to scan and filter the data from an object, potentially increasing query performance by up to 400%, and reducing query costs as much as 80%. You simple change your application to use SELECT instead of GET to take advantage of S3 Select.
• Reduces situations where you have to download massive objects, and incur a large data OUT transfer cost
• Supports CSV, JSON, Parquet, and BZIP2 compression for CSV and JSON
• Glacier is also supported by Glacier Select