Posted On: Nov 17, 2017

Customers can now query Amazon S3 Inventory with standard SQL language using Amazon Athena, Amazon Redshift Spectrum, and other tools such as Presto, Hive, and Spark. You can easily get started by pointing Amazon Athena to the S3 Inventory report in ORC or CSV format with a few clicks, run ad hoc queries, and get results in seconds. This is available in all AWS Regions where Athena is available. Learn more by visiting our developer guide

Customers can now get S3 Inventory in Apache Optimized Row Columnar (ORC) file format. ORC is a self-describing, type-aware columnar file format designed for Hadoop ecosystem workloads. The columnar format lets the reader read, decompress, and process only the columns that are required for the current query. For querying S3 Inventory with Athena, we recommend configuring your inventory for ORC instead of CSV for faster query performance and lower query cost. ORC format for S3 Inventory is available in all AWS Regions. Get started by visiting the S3 Console.