C4W4a1 Transform job error

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
1

Hi, my transform job errors is different than others, or I think so.
For the songs transform error is this one :

image
image1603×561 64 KB

and also for the json transformation job I got this error
image
image1616×550 59 KB

I do not think these problems belongs to glue.tf. I think main problem is in .py files for transformation. But can not find exact reason

2

Hello @JavidM
I suggest you check the following:

  1. You have completed lines 106 to 108 of the de-c4w4a1-transform-songs-job.py file correctly.
    image
  2. You have put the correct Pacific time in the transform_job/glue.tf file.

If you are sure of these two items and still encounter the error, please, request a lab refresh using this form.

3

Hey @Amir_Zare
Thank you for responding.
Actually, the team has refreshed this week I do not think the problem is based on lab refresh. I checked my code and it is like this:
image
Is there any option to regenerate my lab and start again? Or can you please share samples for transform jobs in both 2 .py files? I want to fill them in again maybe I deleted some parts in it. Also, glue.tf file sample for transformation. I want to fill it again also.

4

@JavidM your code seems correct. Here are the raw versions for the 3 files you requested.
c4w4a1.zip (5.0 KB)
Hope it helps.

5

Thank you @Amir_Zare . I completed part1