AWS Cost and Usage Report Automation with CloudFormation

Folder Structure

cost_and_usage_report_stack
│
├── cloudformation
│ ├── MasterTemplate.yaml # Combined CloudFormation template
│
├── athena
│ ├── YourCURReport-create-table.sql # The query created by aws
│ ├── example_query.sql # Example SQL query for Athena
│
├── README.md

Pre-requisites

Before you start, ensure you have:

• An AWS account
• AWS CLI installed and configured
• Appropriate permissions to create AWS resources (S3, Athena, Glue, CUR)

Deployment Steps

1. Create an S3 Bucket

First, create an S3 bucket where your CloudFormation templates and CUR reports will be stored:

aws s3 mb s3://your-cur-reports-bucket-fg --region us-east-1

2. Deploy CloudFormation Stack

Use AWS CLI to deploy the master template:

aws cloudformation create-stack --stack-name your-cur-stack --template-body file://cloudformation/MasterTemplate.yaml --capabilities CAPABILITY_NAMED_IAM

Contributing

Please fork the repository and create pull requests for any improvements or bug fixes.

License

This project is licensed under the MIT License. See the LICENSE file for details.