AWS Cost & Usage Reports Add Amazon Athena Integration, Apache Parquet Output, and Report Overwrite

Posted on: Nov 15, 2018

Amazon Athena is a serverless interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Starting today, you can configure your AWS Cost & Usage Report to automatically integrate with Amazon Athena, making it easier and more cost effective than ever to directly access and query your cost and usage information.

Once Amazon Athena integration has been enabled for your Cost & Usage Report, your data will be delivered in compressed Apache Parquet files to an Amazon S3 bucket of your choice. From there, you can use an out-of-the-box AWS CloudFormation template to perform a one-time configuration of an AWS Glue crawler. This will ensure that your latest cost and usage information is always available to Amazon Athena – with no additional work required to prepare your data for analysis.

The Cost & Usage Report contains the most granular set of AWS cost and usage data available, including metadata about AWS services, pricing, and reservations (e.g., Amazon EC2 Reserved Instances). To learn more about getting started with the Cost & Usage Report, please visit the AWS Cost & Usage Reporting webpage or refer to the Managing AWS Cost & Usage Reports user guide. You can enable your Cost & Usage Report here.