AWS Glue is Amazon's serverless data integration service that orchestrates extract, transform, and load (ETL) workflows at scale. Built on Apache Spark, it eliminates infrastructure management while providing a Data Catalog as a central metadata repository, crawlers for schema inference, and visual and code-based ETL authoring. AWS Glue excels at preparing messy, semi-structured data for analytics β whether through batch jobs, streaming pipelines, or visual no-code transforms. Understanding the distinction between DynamicFrames (Glue's schema-flexible abstraction) and Spark DataFrames, mastering job bookmarks for incremental processing, and leveraging performance optimization techniques like pushdown predicates are essential for cost-effective, production-grade Glue implementations. AWS Glue 5.1 (the current default, released November 2025) runs Spark 3.5.6 with Java 17 and adds Iceberg v3, materialized views, and an AI-powered Spark troubleshooting agent.
What This Cheat Sheet Covers
This topic spans 29 focused tables and 222 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.
A jump-to index of every table row in this cheat sheet.
An interactive map of every table and concept in this topic.
Table 1: Glue Job Types
Choose the right execution model first β the job type determines available runtimes, DPU billing, and integration depth. Spark ETL handles the vast majority of workloads; Python Shell covers lightweight scripted automation; Streaming covers near-real-time pipelines.
| Type | Example | Description |
|---|---|---|
job_type = 'glueetl'worker_type = 'G.2X' | β’ Runs Apache Spark on serverless Glue infrastructure β’ best for large-scale batch processing β’ uses DynamicFrames or standard Spark DataFrames β’ charged per DPU-hour | |
streaming = Truesources: Kinesis, Kafka | β’ Continuous near-real-time processing β’ reads from Kinesis Data Streams or MSK β’ uses Spark Structured Streaming β’ supports checkpointing and micro-batching | |
Created via Glue Studio UI | β’ Drag-and-drop interface for building ETL pipelines without code β’ auto-generates PySpark or Scala scripts β’ supports custom transforms and DataBrew recipes β’ available in SageMaker Unified Studio |