# Glue\_json\_transformation\_job\` and \`glue\_songs\_transformation\_job\` fail

**URL:** <https://community.deeplearning.ai/t/glue-json-transformation-job-and-glue-songs-transformation-job-fail/757951>\
**Category:** Data Modeling, Transformation, and Serving\
**Tags:** week-module-4, coursera-platform\
**Created:** [January 25, 2025, 11:58am UTC](https://community.deeplearning.ai/t/glue-json-transformation-job-and-glue-songs-transformation-job-fail/757951 "2025-01-25T11:58:05Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabriele](https://avatars.discourse-cdn.com/v4/letter/g/76d3ee/32.png) [@Gabriele](https://community.deeplearning.ai/u/Gabriele)\
**Post date:** [January 25, 2025, 11:58am UTC](https://community.deeplearning.ai/t/glue-json-transformation-job-and-glue-songs-transformation-job-fail/757951/1 "2025-01-25T11:58:05Z")

</div>

I’m having problems with running the two jobs in section 2.2 for the c4w4\_assignment\_2. Both are failing and I don’t know why. Iinitially I accidentally didn’t run them and continued the assignment till 3.1 where I realized I didn’t read that instruction. In theory all the steps have been followed now. But they continues failing. Reading other threads I thought a possible problem might be the ingest date in glue.tf and both tried 2020-02-01 (which should be the correct one according to instructions) as well as today (as mentioned in some thread as a solution). Also, I don’t know where I can exactly look for logs in the console (I see messages about missing authorization). Could someone please help me with this?

From Glue console, this might probably be of help: AnalysisException: Insufficient Lake Formation permission(s) on de\_c4w4a2\_transform\_db (Service: AWSGlue; Status Code: 400; Error Code: AccessDeniedException; Request ID: ; Proxy: null)

---

<div class="post-metadata">

**Author:** ![Amir\_Zare](https://sea1.discourse-cdn.com/dlai/user_avatar/community.deeplearning.ai/amir_zare/32/95275_2.png) [@Amir\_Zare](https://community.deeplearning.ai/u/Amir_Zare)\
**Post date:** [January 25, 2025, 6:35pm UTC](https://community.deeplearning.ai/t/glue-json-transformation-job-and-glue-songs-transformation-job-fail/757951/3 "2025-01-25T18:35:48Z")

</div>

Hello @Gabriele  
Running steps in wrong order may break the components. Unfortunately, you don’t have the necessary access to see the logs. I suggest starting a new lab session and trying to follow the steps in correct order. If you face the same issues, specifically the insufficient lake formation permission, please, fill out the [lab refresh form](https://forms.gle/Bbc2PqyjYWnS34jF7).

---

<div class="post-metadata">

**Author:** ![Gabriele](https://avatars.discourse-cdn.com/v4/letter/g/76d3ee/32.png) [@Gabriele](https://community.deeplearning.ai/u/Gabriele)\
**Post date:** [January 25, 2025, 10:00pm UTC](https://community.deeplearning.ai/t/glue-json-transformation-job-and-glue-songs-transformation-job-fail/757951/4 "2025-01-25T22:00:31Z")

</div>

Hello Amir, thanks for answering.  
I’m trying right now, jobs are successful! I’ll tell you how it goes…

---

<div class="post-metadata">

**Author:** ![Gabriele](https://avatars.discourse-cdn.com/v4/letter/g/76d3ee/32.png) [@Gabriele](https://community.deeplearning.ai/u/Gabriele)\
**Post date:** [January 25, 2025, 11:07pm UTC](https://community.deeplearning.ai/t/glue-json-transformation-job-and-glue-songs-transformation-job-fail/757951/5 "2025-01-25T23:07:51Z")

</div>

Everything OK! The lab continued smoothly this time. Thanks for your support

---

<div class="post-metadata">

**Author:** ![pawanshirbhate](https://avatars.discourse-cdn.com/v4/letter/p/9fc348/32.png) [@pawanshirbhate](https://community.deeplearning.ai/u/pawanshirbhate)\
**Post date:** [March 6, 2025, 8:36am UTC](https://community.deeplearning.ai/t/glue-json-transformation-job-and-glue-songs-transformation-job-fail/757951/6 "2025-03-06T08:36:54Z")

</div>

Despite of following the steps in correct order, I’m also facing the same problem at step 2.5 of C4W4\_Part2 project.

Both `glue_json_transformation_job` and `glue_songs_transformation_job` are encountering the following error.  
_AnalysisException: Insufficient Lake Formation permission(s) on de\_c4w4a2\_silver\_db (Service: AWSGlue; Status Code: 400; Error Code: AccessDeniedException; Request ID: f61dd05a-181a-4489-bd0f-d8bd89261d50; Proxy: null)_

Moreover, I’m unable to fill the lab refresh form due to following issue:

“Data Engineering - Lab Issue Question  
The form Data Engineering - Lab Issue Question is no longer accepting responses.  
Try contacting the owner of the form if you think this is a mistake.”

Kindly help.

---

<div class="post-metadata">

**Author:** ![Amir\_Zare](https://sea1.discourse-cdn.com/dlai/user_avatar/community.deeplearning.ai/amir_zare/32/95275_2.png) [@Amir\_Zare](https://community.deeplearning.ai/u/Amir_Zare)\
**Post date:** [March 7, 2025, 8:14am UTC](https://community.deeplearning.ai/t/glue-json-transformation-job-and-glue-songs-transformation-job-fail/757951/7 "2025-03-07T08:14:09Z")

</div>

Hello @pawanshirbhate  
I guess you were using an obsolete version of the lab refresh form. Here is the [link](https://forms.gle/S2gLNzQXZuMhBGwL6) to the most current version.
