Advanced Operations with Amazon Athena

If you're working with Amazon Athena, or thinking of using it to query your data lake, you can see how to take Amazon's serverless big data query tool to a whole new level. Learn all the important things to make the most of your Athena setup.
Course info
Level
Advanced
Updated
Jun 25, 2019
Duration
2h 19m
Table of contents
Description
Course info
Level
Advanced
Updated
Jun 25, 2019
Duration
2h 19m
Description

Enterprises often face a formidable challenge when choosing a tool for analyzing terabytes or even petabytes of business-critical data stored in Amazon S3. Fortunately, there's Athena, a low-cost, easy-to-use, serverless query tool with a powerful Hive backend and a Presto query engine that allows you to run SQL queries on S3 data. Learning the basics of Athena is simple, but how do you make it secure? How do you make it automated? How do you run dashboards off it? In this course, Advanced Operations with Amazon Athena, you will learn the necessary skills to make your Athena setup more efficient and production-ready. First, you will learn how to use Amazon Glue to create Athena tables from unknown data sources. You will see how to run queries on complex data structures. Next, you will make your Athena applications more secure with policies and encryptions. Going even further, you will learn how to automate Athena data processing with other serverless tools like Lambda. Finally, you will build Tableau charts from Athena views and publish those charts to a Tableau server. When you’re finished with this course, you will be equipped with advanced skills and knowledge to run a robust Athena setup. You will also get your hands dirty working with other technologies.

About the author
About the author

Sadequl Hussain is an information technologist and digital content producer from Sydney, Australia. He has more than twenty years of experience in development, infrastructure engineering, database management, training, and technical authoring.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Sadequl Hussain. Welcome to my course, Advanced Operations with Amazon Athena. I'm an information technologist and digital content producer from Sydney, Australia, and have more than 20 years of experience working with databases, application development, infrastructure engineering, training, and technical writing. Many companies face a challenge when choosing a tool for analyzing terabytes or even petabytes of business-critical data they have stored in Amazon S3. AWS Athena is Amazon's answer to that. It's a low cost, serverless query tool that lets you run interactive SQL queries on S3 data. Learning the basics of Athena is simple. You might be using it already, or you may be considering it for your next project, however, you need to go deeper than just the basics to use it effectively. In this course, we are going to learn some advanced techniques of running and managing Athena applications. The major topics we will cover here include how to use Amazon Glue with Amazon Athena, how to query complex data structures from Athena, how to secure Athena applications, how to automate Athena workflows, and how to visualize the data exposed from Athena. By the end of this course, you will have enough skills and knowledge to feel confident about managing any production Athena workflow. Before beginning this course, you should have some basic familiarity with Amazon Athena and other AWS services like S3, IAM, KMS, and Lambda. You should be also be comfortable writing basic SQL queries. Any familiarity with programming languages like Python or tools like Tableau will be greatly helpful. I hope you will join me on this journey to learn more about this simple, but effective analytics tool in the Advanced Operations with Amazon Athena course here at Pluralsight.