Interactively develop your AWS Glue streaming ETL jobs utilizing AWS Glue Studio notebooks

Enterprise clients are modernizing their information warehouses and information lakes to offer real-time insights, as a result of having the suitable insights on the proper time is essential for good enterprise outcomes. To allow near-real-time decision-making, information pipelines must course of real-time or near-real-time information. This information is sourced from IoT gadgets, change information seize (CDC) companies like AWS Information Migration Service (AWS DMS), and streaming companies reminiscent of Amazon Kinesis, Apache Kafka, and others. These information pipelines should be sturdy, in a position to scale, and in a position to course of giant information volumes in near-real time. AWS Glue streaming extract, remodel, and cargo (ETL) jobs course of information from information streams, together with Kinesis and Apache Kafka, apply complicated transformations in-flight, and cargo it right into a goal information shops for analytics and machine studying (ML).

Lots of of shoppers are utilizing AWS Glue streaming ETL for his or her near-real-time information processing necessities. These clients required an interactive functionality to course of streaming jobs. Beforehand, when creating and working a streaming job, you needed to look forward to the outcomes to be obtainable within the job logs or endured right into a goal information warehouse or information lake to have the ability to view the outcomes. With this method, debugging and adjusting code is troublesome, leading to an extended improvement timeline.

At the moment, we’re launching a brand new AWS Glue streaming ETL characteristic to interactively develop streaming ETL jobs in AWS Glue Studio notebooks and interactive classes.

On this put up, we offer a use case and step-by-step directions to develop and debug your AWS Glue streaming ETL job utilizing a pocket book.

Resolution overview

To show the streaming interactive classes functionality, we develop, check, and deploy an AWS Glue streaming ETL job to course of Apache Webserver logs. The next high-level diagram represents the move of occasions in our job.
BDB-2464 High Level Application Architecture
Apache Webserver logs are streamed to Amazon Kinesis Information Streams. An AWS Glue streaming ETL job consumes the info in near-real time and runs an aggregation that computes what number of instances a webpage has been unavailable (standing code 500 and above) as a consequence of an inner error. The mixture data is then printed to a downstream Amazon DynamoDB desk. As a part of this put up, we develop this job utilizing AWS Glue Studio notebooks.

You may both work with the directions offered within the pocket book, which you obtain when instructed later on this put up, or comply with together with this put up to writer your first streaming interactive session job.


To get began, click on the Launch Stack button beneath, to run an AWS CloudFormation template in your AWS setting.


The template provisions a Kinesis information stream, DynamoDB desk, AWS Glue job to generate simulated log information, and the required AWS Identification and Entry Administration (IAM) function and polices. After you deploy your assets, you’ll be able to evaluation the Assets tab on the AWS CloudFormation console for detailed data.

Arrange the AWS Glue streaming interactive session job

To arrange your AWS Glue streaming job, full the next steps:

  1. Obtain the pocket book file and reserve it to a neighborhood listing in your pc.
  2. On the AWS Glue console, select Jobs within the navigation pane.
  3. Select Create job.
  4. Choose Jupyter Pocket book.
  5. Below Choices, choose Add and edit an present pocket book.
  6. Select Select file and browse to the pocket book file you downloaded.
  7. Select Create.
BDB-2464 Create Job
  1. For Job title¸ enter a reputation for the job.
  2. For IAM Position, use the function glue-iss-role-0v8glq, which is provisioned as a part of the CloudFormation template.
  3. Select Begin pocket book job.
BDB-2464 Start Notebook

You may see that the pocket book is loaded into the UI. There are markdown cells with directions in addition to code blocks you could run sequentially. You may both run the directions on the pocket book or comply with together with this put up to proceed with the job improvement.

BDB-2464 Explore Notebook

Run pocket book cells

Let’s run the code block that has the magics. The pocket book has notes on what every magic does.

  1. Run the primary cell.
BDB-2464 Run First Cell

After working the cell, you’ll be able to see within the output part that the defaults have been reconfigured.

BDB-2464 Configurations Set

Within the context of streaming interactive classes, an vital configuration is job sort, which is ready to streaming. Moreover, to reduce prices, the variety of staff is ready to 2 (default 5), which is ample for our use case that offers with a low-volume simulated dataset.

Our subsequent step is to initialize an AWS Glue streaming session.

  1. Run the subsequent code cell.
BDB-2464 Initiate Session

After we run this cell, we will see {that a} session has been initialized and a session ID is created.

A Kinesis information stream and AWS Glue information generator job that feeds into this stream have already been provisioned and triggered by the CloudFormation template. With the subsequent cell, we devour this information as an Apache Spark DataFrame.

  1. Run the subsequent cell.
BDB-2464 Fetch From Kinesis

As a result of there are not any print statements, the cells don’t present any output. You may proceed to run the next cells.

Discover the info stream

To assist improve the interactive expertise in AWS Glue interactive classes, GlueContext offers the tactic getSampleStreamingDynamicFrame. It offers a snapshot of the stream in a static DynamicFrame. It takes three arguments:

  • The Spark streaming DataFrame
  • An choices map
  • A writeStreamFunction to use a operate to each sampled report

Accessible choices are as follows:

  • windowSize – Also referred to as the micro-batch period, this parameter determines how lengthy a streaming question will wait after the earlier batch was triggered.
  • pollingTimeInMs – That is the entire size of time the tactic will run. It begins not less than one micro-batch to acquire pattern information from the enter stream. The time unit is milliseconds, and the worth ought to be better than the windowSize.
  • recordPollingLimit – That is defaulted to 100, and helps you set an higher certain on the variety of information that’s retrieved from the stream.

Run the subsequent code cell and discover the output.

BDB-2464 Sample Data

We see that the pattern consists of 100 information (the default report restrict), and we’ve got efficiently displayed the primary 10 information from the pattern.

Work with the info

Now that we all know what our information seems to be like, we will write the logic to wash and format it for our analytics.

Run the code cell containing the reformat operate.

Observe that Python UDFs aren’t the beneficial option to deal with information transformations in a Spark utility. We use reformat() to exemplify troubleshooting. When working with a real-world manufacturing utility, we advocate utilizing native APIs wherever doable.

BDB-2464 Run The UDF

We see that the code cell did not run. The failure was on objective. We intentionally created a division by zero exception in our parser.

BDB-2464 Error Running The Code

Failure and restoration

In case of a daily AWS Glue job, for any error, the entire utility exits, and you must make code modifications and resubmit the applying. Nevertheless, in case of interactive classes, the coding context and definitions are absolutely preserved and the session continues to be operational. There isn’t a must bootstrap a brand new cluster and rerun all of the previous transformation. This lets you give attention to shortly iterating your batch operate implementation to acquire the specified end result. You may repair the defects and run them in a matter of seconds.

To check this out, return to the code and remark or delete the inaccurate line error_line=1/0 and rerun the cell.

BDB-2464 Error Corrected

Implement enterprise logic

Now that we’ve got efficiently examined our parsing logic on the pattern stream, let’s implement the precise enterprise logic. The logics are applied within the processBatch methodology inside the subsequent code cell. On this methodology, we do the next:

  • Move the streaming DataFrame in micro-batches
  • Parse the enter stream
  • Filter messages with standing code >=500
  • Over a 1-minute interval, get the depend of failures per webpage
  • Persist the previous metric to a DynamoDB desk (glue-iss-ddbtbl-0v8glq)
  1. Run the subsequent code cell to set off the stream processing.
BDB-2464 Trigger DDB Write
  1. Wait a couple of minutes for the cell to finish.
  2. On the DynamoDB console, navigate to the Gadgets web page and choose the glue-iss-ddbtbl-0v8glq desk.
BDB-2464 Explore DDB

The web page shows the aggregated outcomes which have been written by our interactive session job.

Deploy the streaming job

Up to now, we’ve got been creating and testing our utility utilizing the streaming interactive classes. Now that we’re assured of the job, let’s convert this into an AWS Glue job. We now have seen that almost all of code cells are doing exploratory evaluation and sampling, and aren’t required to be part of the primary job.

A commented code cell that represents the entire utility is offered to you. You may uncomment the cell and delete all different cells. An alternative choice can be to not use the commented cell, however delete simply the 2 cells from the pocket book that do the sampling or debugging and print statements.

To delete a cell, select the cell after which select the delete icon.

BDB-2464 Delete a Cell

Now that you’ve got the ultimate utility code prepared, save and deploy the AWS Glue job by selecting Save.

BDB-2464 Save Job

A banner message seems when the job is up to date.

BDB-2464 Save Job Banner

Discover the AWS Glue job

After you save the pocket book, it is best to have the ability to entry the job like every common AWS Glue job on the Jobs web page of the AWS Glue console.

BDB-2464 Job Page

Moreover, you’ll be able to have a look at the Job particulars tab to verify the preliminary configurations, reminiscent of variety of staff, have taken impact after deploying the job.

BDB-2464 Job Details Page

Run the AWS Glue job

If wanted, you’ll be able to select Run to run the job as an AWS Glue streaming job.

BDB-2464 Job Run

To trace progress, you’ll be able to entry the run particulars on the Runs tab.

BDB-2464 Job Run Details

Clear up

To keep away from incurring further prices to your account, cease the streaming job that you simply began as a part of the directions. Additionally, on the AWS CloudFormation console, choose the stack that you simply provisioned and delete it.


On this put up, we demonstrated how one can do the next:

  • Writer a job utilizing notebooks
  • Preview incoming information streams
  • Code and repair points with out having to publish AWS Glue jobs
  • Overview the end-to-end working code, take away any debugging, and print statements or cells from the pocket book
  • Publish the code as an AWS Glue job

We did all of this through a pocket book interface.

With these enhancements within the total improvement timelines of AWS Glue jobs, it’s simpler to writer jobs utilizing the streaming interactive classes. We encourage you to make use of the prescribed use case, CloudFormation stack, and pocket book to jumpstart your particular person use instances to undertake AWS Glue streaming workloads.

The purpose of this put up was to offer you hands-on expertise working with AWS Glue streaming and interactive classes. When onboarding a productionized workload onto your AWS setting, primarily based on the info sensitivity and safety necessities, make sure you implement and implement tighter safety controls.

Concerning the authors

Arun A Ok is a Large Information Options Architect with AWS. He works with clients to offer architectural steering for working analytics options on the cloud. In his free time, Arun likes to get pleasure from high quality time together with his household.

Linan Zheng is a Software program Improvement Engineer at AWS Glue Streaming Crew, serving to constructing the serverless information platform. His works contain giant scale optimization engine for transactional information codecs and streaming interactive classes.

Roman Gavrilov is an Engineering Supervisor at AWS Glue. He has over a decade of expertise constructing scalable Large Information and Occasion-Pushed options. His staff works on Glue Streaming ETL to permit close to actual time information preparation and enrichment for machine studying and analytics.

Shiv Narayanan is a Senior Technical Product Supervisor on the AWS Glue staff. He works with AWS clients throughout the globe to strategize, construct, develop, and deploy trendy information platforms.

Latest articles

Related articles

Leave a reply

Please enter your comment!
Please enter your name here