Tutorial: Build your first streaming workload using Amazon Glue Studio notebooks

To get started, click to run an Amazon CloudFormation template on your Amazon environment.

The template provisions a Kinesis data stream and a Kinesis Data Generator account for you.

Enter a Username and Password that the KDG will use to authenticate. Note the username and password for further usage.

Select Next all the way to the last step. Acknowledge the creation of IAM resources. Check for any errors at the top of the screen, such as the password not meeting the minimum requirements, and deploy the template.

Navigate to the Outputs tab of the stack. Once the template is deployed, it will display the generated property KinesisDataGeneratorUrl. Click that URL.

Enter the Username and Password you noted down.

Select the Region you are using and select the Kinesis Stream GlueStreamTest-{AWS::AccountId}

Enter the following template:

{
    "ventilatorid": {{random.number(100)}},
    "eventtime": "{{date.now("YYYY-MM-DD HH:mm:ss")}}",
    "serialnumber": "{{random.uuid}}",
    "pressurecontrol": {{random.number(
        {
            "min":5,
            "max":30
        }
    )}},
    "o2stats": {{random.number(
        {
            "min":92,
            "max":98
        }
    )}},
    "minutevolume": {{random.number(
        {
            "min":5,
            "max":8
        }
    )}},
    "manufacturer": "{{random.arrayElement(
        ["3M", "GE","Vyaire", "Getinge"]
    )}}"
}

You can now view mock data with Test template and ingest the mock data to Kinesis with Send data.

Click Send data and generate 5-10K records to Kinesis.

Download the provided notebook file and save it to a local directory

Open the Amazon Glue Console and on the left pane click Notebooks > Jupyter Notebook > Upload and edit an existing notebook. Upload the notebook from the previous step and click Create.

Provide the job a name, role and select the default Spark kernel. Next click Start notebook. For the IAM Role, select the role provisioned by the CloudFormation template. You can see this in the Outputs tab of CloudFormation.

(Optional) The first code cell, %help lists all available notebook magics. You can skip this cell for now, but feel free to explore it.

Start with the next code block %streaming. This magic sets the job type to streaming which lets you develop, debug and deploy an Amazon Glue streaming ETL job.

Run the next cell to create an Amazon Glue interactive session. The output cell has a message that confirms the session creation.

The next cell defines the variables. Replace the values with ones appropriate to your job and run the cell. For example:

Since the data is being streamed already to Kinesis Data Streams, your next cell will consume the results from the stream. Run the next cell. Since there are no print statements, there is no expected output from this cell.

In the following cell, you explore the incoming stream by taking a sample set and print its schema and the actual data. For example:

Next, define the actual data transformation logic. The cell consists of the processBatch method that is triggered during every micro-batch. Run the cell. At a high level, we do the following to the incoming stream:

In the last cell, you trigger the process batch every 10 seconds. Run the cell and wait for about 30 seconds for it to populate the Amazon S3 bucket and the Amazon Glue catalog table.

Finally, browse the stored data using the Amazon Athena query editor. You can see the renamed column and also the new partitions.