In the 2nd capstone project, when I run the transform glue etl jobs, this error is thrown AnalysisException: Insufficient Lake Formation permission(s) on de_c4w4a2_transform_db (Service: AWSGlue; Status Code: 400; Error Code: AccessDeniedException; Request ID: 1f805925-459a-469b-a88d-847d090dc658; …

Hello @sahil251298 Sorry for the inconvenience. Can you please fill out the lab refresh form and try again after your lab is refreshed?

Hi Amir, I’m having the same permission problem, and follow the link you provided. So now I should wait is correct? Thank you

Hello @rrosa Yes. Please, wait up to 3 business days and try again after.

Hi Amir, I hope you’re doing well! I’m not sure if I’ve done something wrong or missed a step, but when running the following command in the Visual Studio Code terminal as instructed in the Jupyter notebook: aws glue start-job-run --job-name de-c4w4a2-json-transform-job I encountered the same is…

Hello @rrosa The Insufficient Lake Formation permission can be fixed via a lab refresh. Please, fill out this lab refresh form and try again after 3 working days.

Hi @Amir_Zare Im getting the following error after running the glue start-job-run. Can I get help on this please? An error occurred (AccessDeniedException) when calling the StartJobRun operation: User: arn:aws:sts::471112906237:assumed-role/VSCodeInstanceRole/i-0353661b5af2b206e is not authorized t…

Hello @Edmund_Koh I guess you are using a wrong value for the job name in the glue start job command. Please, provide the full command you use so that we can check it.

Hey @Amir_Zare attached my input [Screenshot 2025-02-12 at 3.16.48 PM]

@Edmund_Koh As I said, glue_api_user_extract_job is not the correct job name. You need to get the value of the output named glue_api_user_extract_job from terraform and use that value as the job name in the command.

Hi Amir, It took me a little while to retry, but I finally got around to it today, and everything ran smoothly! I just wanted to update you and sincerely thank you for your help—I really appreciate it! Best regards, Rui Rosa

C4W4 Capstone project 2. Glue ETL jobs throwing access error

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

bchibbard February 23, 2025, 12:01am 15

I found a link in this article that allowed me to submit a refresh. I’m standing by for that!

Topic		Replies	Views
C4W4 Capstone Part 2 Issues - Insufficient Lake Formation permission(s) Glue Jobs Data Modeling, Transformation, and Serving week-module-4 , coursera-platform	26	321	March 14, 2025
C4W4A2 - Capstone Lab - Error when trying to run glue job Data Modeling, Transformation, and Serving week-module-4 , coursera-platform	1	145	December 15, 2024
Glue_json_transformation_job` and `glue_songs_transformation_job` fail Data Modeling, Transformation, and Serving week-module-4 , coursera-platform	5	111	March 7, 2025
C4_W4 Lab - Insufficient Lake Formation permission(s) Data Modeling, Transformation, and Serving week-module-4 , coursera-platform	26	315	September 3, 2025
C4W4 -Capstone Project Part 1: Permission error Data Modeling, Transformation, and Serving week-module-4 , coursera-platform	2	112	December 11, 2024

C4W4 Capstone project 2. Glue ETL jobs throwing access error

Related topics