AWS Application Cost Monitoring - S3 Writer For Athena

Application Cost Monitoring provides granular AWS spend tracking. This will write items from AWS Application Cost Monitoring so AWS S3 for analysis with AWS Athena or AWS Quicksight.

This requires AWS Application Cost Monitoring to be deployed first. This will subscribe to the SNS topic of that service and publish messages produced by it to S3.

Deployment

This can be deployed using Serverless Framework or AWS Serverless Application Repository (AppRepo). Due to limitations in AppRepo, you will need to setup the AWS Glue Crawler for Athena manually.

You must also deploy the AWS Application Cost Monitoring service first. That provides the billing report and ingestion pipeline. This repository will subscribe to the message topic provided by that service.

Serverless Framework

Clone of this repository by using Serverless Framework.

$ npm install -g serverless
$ npm install
$ serverless deploy -v

AWS Serverless Application Repository

See the README and instructions at:

• https://serverlessrepo.aws.amazon.com/#/applications/arn:aws:serverlessrepo:us-east-1:641494176294:applications~ACM-S3-Publisher

Usage

Once a report is run and Glue crawler has run, the line_items table will be available in the application_cost_monitoring database. Use AWS Athena or AWS Quicksight to query the data.