Amazon Athena - Review

The course is part of this learning path

AWS Big Data – Specialty Certification Preparation for AWS
course-steps 14 certification 1 lab-steps 4 quiz-steps 4

Contents

keyboard_tab
Amazon Athena - In-depth Review
play-arrow
Start course
Overview
DifficultyIntermediate
Duration32m
Students669
Ratings
5/5
star star star star star

Description

In this course, we will perform an in-depth review of the Amazon Athena service. We will review and explain fundamental AWS Athena storage and querying concepts. We will highlight suitable use cases in which Athena can be applied effectively. You will be introduced to the basic underlying technology that Athena has been built on. We spend time discussing the process of creating and setting up Athena databases, tables, and partitions. We examine the process in which Athena SQL queries are authored and how they are managed. We review current Athena limitations and pricing. Finally, we will provide a demonstration in which we publish CloudTrail logs into an S3 bucket. We make some ad-hoc security group changes to generate a few CloudTrail events - and finally we’ll use Athena to search and find the captured security group API update calls.

Transcript

- [Instructor] Before we finish, let's do a quick review of what we've learned. We reviewed and explained basic AWS Athena storage and querying concepts. We highlighted suitable use cases in which Athena can be applied effectively. We reviewed the basic underlying technology that Athena has been built on. We discussed and illustrated the process of creating and setting up Athena tables, formats, and partitions. We examined the process in which Athena SQL queries are authored.

We reviewed current Athena limitations and pricing. Finally, we provided an end to end demonstration in which we published and queried CloudTrail logs using Athena SQL queries. Thank you for your participation.

I do hope you enjoyed this course on Amazon Athena. Feel free to send any feedback and or questions at support@cloudacademy.com. Alternatively, you could always get in touch with us here at CloudAcademy using the community forum where one of our Cloud Experts will reply to your question.

About the Author

Students10069
Labs26
Courses61
Learning paths14

Jeremy is the DevOps Content Lead at Cloud Academy where he specializes in developing technical training documentation for DevOps.

He has a strong background in software engineering, and has been coding with various languages, frameworks, and systems for the past 20+ years. In recent times, Jeremy has been focused on DevOps, Cloud, Security, and Machine Learning.

Jeremy holds professional certifications for both the AWS and GCP cloud platforms.