Preparing the database
In this lab, we use available data about AWS Cost & Usage Report.
The first step, to build a database for query purposes from Amazon Athena through AWS Glue, we need to have data based on AWS Cost & Usage Report. However, getting this report will take at least 24h, so we have prepared the report files.
- Go to AWS Management Console
- In the S3 interface
- Select Buckets
- Select Create bucket
- In the Create bucket interface
- Bucket name, enter
cost-and-usage-analysis
- Select Create bucket
- Finish creating S3 bucket
- Select cost-and-usage-analysis bucket
- In cost-and-usage-analysis bucket
- Create a folder to store data by selecting Create folder
- In the Create folder interface
- Folder name, enter
Monthly-Report
- Select Create folder
- We perform Upload of data files
- Select downloaded data files
- Select Add files
- Select data files
- Select Upload
- When uploading status changes to Succeeded