Chapter 4: Serverless Amazon Athena and the AWS Glue Data Catalog

Solution for Activity 5: Building a AWS Glue catalog for a CSV-Formatted Dataset and Analyzing the Data Using AWS Athena

1. Log in to your AWS account.
2. Upload the data file total-business-inventories-to-sales-ratio.csv (provided with this book) into a S3 bucket. Make sure that the required permissions are in place:
   

   Figure 4.24: Uploading the data file

3. Go to the AWS Glue service.
4. Select Crawlers and click on Add Crawler.
5. Provide the crawler name and click on Next.
6. Provide the path of the S3 bucket, where the file was uploaded in step 2. Click on Next.
7. Click on Next, as we don't want to add another data store.
8. Choose an existing IAM role that was created in Exercise 11: Using AWS Glue to Build a Metadata Repository. Alternatively, you can create a new one. Click on Next.
9. Let's keep it as Run on demand and click on Next.
10. Either you can create a new database here or click...