Prepare database

In this lab, we use available data on AWS Cost & Usage Report.

The first step, to build a database for the purpose of querying from Amazon Athena through AWS Glue, we need to have data based on the AWS Cost & Usage Report. However, it will take at least 24h to get this report, so we have prepared the report files.

1. Access AWS Management Console

• Search S3
• Select S3

1. In the S3 interface

• Select General purpose buckets
• Select Create bucket

3. In the Create bucket interface

• Bucket namespace select Account Regional namespace (recommended)
• Bucket name, enter cost-and-usage-analysis

4. Select Create bucket

5. In cost-and-usage-analysis-xxxxxxxxxx-us-east-1-an bucket

• Create a folder to store data by selecting Create folder

6. In the Create folder interface

• Folder name, enter Monthly-Report
• Select Create folder

7. We proceed to Upload data files

8. Select the downloaded data files

• Select Add files
• Select the data files

10. Select Upload

11. When the upload status changes to Succeeded