Querying data within an S3 bucket using AWS Glue and Amazon Athena

In this hands-on lab, we are going to use some public sample flight data that is stored within a public S3 bucket to create an AWS Glue table. Then, we are going to run queries against that AWS Glue table to find out some flight information. Let's get started:

1. Log in to the AWS Console and navigate to AWS Glue.
2. Click on Crawlers from the main left-hand menu and then click Add crawler.
3. Enter DBCertCrawler for Crawler name and click Next.
4. Leave all the defaults on the Specify crawler source type page as-is:

Figure 11.8 – Specify crawler source type

5. On the next page, leave the data source as S3 and click Add connection. Complete the popup by using the following details:
   1. Name: DBCertFlight
   2. Include path: s3://athena-examples/flight/

The following screenshot shows how the form should be completed:

Figure 11.9 – Add a data store...