Test database

We proceed to create an S3 bucket to store the query results.

1. Access S3

• Select General purpose buckets
• Select Create bucket

2. In the Create bucket interface

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

3. Select Create bucket

4. Create a folder to store query data

• Select Create folder

5. Create folder

• Folder name, enter Athena-Query-Results
• Select Create folder

6. Complete creating folder

7. Access AWS Management Console

• Search Athena
• Select Athena

8. To interact with the data table, we need to configure the location to save the query results on S3.

• Select Query editor
• Select Query settings

9. Select Manage

10. Select the S3 path to store

11. Then, select Editor

12. Recheck and perform the query

• Data Source, select AwsDataCatalog
• Database, select costmaster
• Table, select monthly_report
• Perform the query with the following command: the table data is saved into Amazon Athena’s metastore.

MSCK REPAIR TABLE monthly_report;

• Select Run
• Complete the query Query successful

14. Preview the system to check the ability to query data tables on AWS Glue

• Select monthly_report table
• Select Preview Table

SELECT * FROM "costmaster"."monthly_report"
LIMIT 10;