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.
intermediate
Certificate of Completion
Learning Objectives
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:
Trusted by 1.4 million developers working at companies including
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.
![TestimonialsImg](/static/imgs/FelipeMatheus.png)
I highly recommend Educative. The courses are well organized and easy to understand.
![TestimonialsImg](/static/imgs/AdinaOng.png)
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.
![TestimonialsImg](/static/imgs/CliffordFajardo.png)
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.
![TestimonialsImg](/static/imgs/CliffordFajardo.png)
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.
![TestimonialsImg](/static/imgs/FelipeMatheus.png)
I highly recommend Educative. The courses are well organized and easy to understand.
![TestimonialsImg](/static/imgs/AdinaOng.png)
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.
![TestimonialsImg](/static/imgs/CliffordFajardo.png)
Get access to Educative Cloud Labs