Book Image

Serverless ETL and Analytics with AWS Glue

By : Vishal Pathak, Subramanya Vajiraya, Noritaka Sekiyama, Tomohiro Tanaka, Albert Quiroga, Ishan Gaur
Book Image

Serverless ETL and Analytics with AWS Glue

By: Vishal Pathak, Subramanya Vajiraya, Noritaka Sekiyama, Tomohiro Tanaka, Albert Quiroga, Ishan Gaur

Overview of this book

Organizations these days have gravitated toward services such as AWS Glue that undertake undifferentiated heavy lifting and provide serverless Spark, enabling you to create and manage data lakes in a serverless fashion. This guide shows you how AWS Glue can be used to solve real-world problems along with helping you learn about data processing, data integration, and building data lakes. Beginning with AWS Glue basics, this book teaches you how to perform various aspects of data analysis such as ad hoc queries, data visualization, and real-time analysis using this service. It also provides a walk-through of CI/CD for AWS Glue and how to shift left on quality using automated regression tests. You’ll find out how data security aspects such as access control, encryption, auditing, and networking are implemented, as well as getting to grips with useful techniques such as picking the right file format, compression, partitioning, and bucketing. As you advance, you’ll discover AWS Glue features such as crawlers, Lake Formation, governed tables, lineage, DataBrew, Glue Studio, and custom connectors. The concluding chapters help you to understand various performance tuning, troubleshooting, and monitoring options. By the end of this AWS book, you’ll be able to create, manage, troubleshoot, and deploy ETL pipelines using AWS Glue.
Table of Contents (20 chapters)
1
Section 1 – Introduction, Concepts, and the Basics of AWS Glue
5
Section 2 – Data Preparation, Management, and Security
13
Section 3 – Tuning, Monitoring, Data Lake Common Scenarios, and Interesting Edge Cases

Lineage

Data lineage is the process of visualizing and understanding the flow of data within your data lake. Lineage is critical for data engineers and analysts to understand how data is processed and transformed within the data lake. This section covers the tools Glue provides in regard to lineage.

Glue DataBrew

Glue DataBrew (https://aws.amazon.com/glue/features/databrew/) is a serverless data lineage tool integrated within the AWS Glue ecosystem. DataBrew provides a visual and interactive way of visualizing, transforming, and automating data processing within a Glue data lake.

There are a few key components of DataBrew, as outlined here:

  • Datasets: In order to work with data in DataBrew, it must be registered as a dataset. This can be an S3 location, a JDBC database, or a Glue table.
  • Projects: A project is a visualization environment that loads a sample of a dataset and allows you to apply transformations and see their results live. Once the user is happy with...