Create a Data Lake with Lake Formation and Analyze It with Athena
Create a Data Lake with Lake Formation and Analyze It with Athena

CLOUD LABS

Create a Data Lake with Lake Formation and Analyze It with Athena

In this Cloud Lab, you’ll learn how to use AWS Lake Formation to create a secure data lake with Amazon S3 as the data source and query that data using Amazon Athena.

7 Tasks

intermediate

1hr

Certificate of Completion

Desktop OnlyDevice is not compatible.
No Setup Required
Amazon Web Services

Learning Objectives

Working knowledge of how to create a database in AWS Lake Formation
The ability to create catalog tables in a data lake with AWS Glue crawler
An understanding of how to secure data in a data lake with AWS Lake Formation
The ability to efficiently retrieve data from data lake with Amazon Athena

Technologies
AWS logoAWS
Athena
S3
Cloud Lab Overview

AWS Lake Formation is a service that allows users to build and manage secure data lakes. It allows the creation of databases with different data sources. It also uses AWS Glue Crawler, which can extract metadata from different data sources and convert it to tables, making it available for various different types of data analytics. It allows data import from multiple sources and manages them in a centralized data catalog. Moreover, it manages access to datasets and can grant fine-grained permissions to the users who are supposed to access the data in the data lake.

With Athena, you can analyze large amounts of data in a data lake without setting up and managing any infrastructure, given that you are an authorized user. Athena is serverless and can automatically scale up to query any amount of data stored in the data lake, and you only pay for the queries you run.

In this Cloud Lab, you’ll create an S3 bucket with your data stored in it. Then, you’ll configure your data lake with AWS Lake Formation. You’ll set up a database in AWS LakeFormation with an S3 bucket as its source. After that, you’ll use the AWS Glue crawler to convert data into tables and save them in the data lake. Moreover, you’ll grant permission to a user to access the data lake. At last, you’ll query the data in the data lake through Amazon Athena.

After the completion of this Cloud Lab, the provisioned infrastructure of this lab will be similar to the one given below:

The architecture diagram
The architecture diagram

Cloud Lab Tasks
1.Introduction
Getting Started
2.Set Up S3 Bucket and Data Lake
Create an S3 Bucket
Configure Data Lake
3.Catalog and Query Data
Configure and Run a Crawler in Glue
Query Data with Athena
4.Conclusion
Clean Up
Wrap Up
Labs Rules Apply
Stay within resource usage requirements.
Do not engage in cryptocurrency mining.
Do not engage in or encourage activity that is illegal.

Trusted by 1.4 million developers working at companies including

Don’t take our word for it. See what our developers have to say.

Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms.

Felipe Matheus
TestimonialsImg

I highly recommend Educative. The courses are well organized and easy to understand.

Adina Ong
TestimonialsImg

I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.

Clifford Fajardo
TestimonialsImg

I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.

Clifford Fajardo
TestimonialsImg
Don’t take our word for it. See what our developers have to say.

Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms.

Felipe Matheus
TestimonialsImg

I highly recommend Educative. The courses are well organized and easy to understand.

Adina Ong
TestimonialsImg

I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.

Clifford Fajardo
TestimonialsImg

Get access to Educative Cloud Labs

Course Footer Image
Course Footer Image