To create a database and table in Athena, you need to describe the schema and the location where the table data are located in Amazon S3 for read-time querying.

Procedure

  1. Go to CloudTrail → Event history.
  2. Click Create Athena table.
    event-history=949ce821-dc34-4372-a902-42ce0a95d3e9.png
  3. Select the bucket name of the bucket storing the trail logs (ex. "my-trail-logs-bucket-name") for Storage location.
    create-table-in-aws=dc93cbea-fd81-4a99-91a0-48de36587811.png
  4. Click Create table.