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)
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.
Hello Amir, thanks for answering.
I’m trying right now, jobs are successful! I’ll tell you how it goes…
Everything OK! The lab continued smoothly this time. Thanks for your support
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.
Hello @pawanshirbhate
I guess you were using an obsolete version of the lab refresh form. Here is the link to the most current version.