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.

You can download the data at Cost and Usage Analysis. Prerequisite

  1. Go to AWS Management Console
  • Find S3
  • Select S3

Prerequisite

  1. In the S3 interface
  • Select Buckets
  • Select Create bucket

Prerequisite

  1. In the Create bucket interface
  • Bucket name, enter cost-and-usage-analysis

Prerequisite

  1. Select Create bucket

Prerequisite

  1. Finish creating S3 bucket
  • Select cost-and-usage-analysis bucket

Prerequisite

  1. In cost-and-usage-analysis bucket
  • Create a folder to store data by selecting Create folder

Prerequisite

  1. In the Create folder interface
  • Folder name, enter Monthly-Report
  • Select Create folder

Prerequisite

  1. We perform Upload of data files

Prerequisite

  1. Select downloaded data files
  • Select Add files
  • Select data files

Prerequisite

  1. Select Upload

Prerequisite

  1. When uploading status changes to Succeeded

Prerequisite