C1W2 lab, error while running the etl job

An error occurred while calling o138.pyWriteDynamicFrame. Insufficient Lake Formation permission(s) on dim_customers (Service: AWSGlue; Status Code: 400; Error Code: AccessDeniedException; Request ID: 883f4bef-73d3-4975-8ab0-70f792294f21; Proxy: 169.254.76.0)

Hello @Ammaro,

This issue with the glue job fails can be fixed with a lab refresh. Please submit this form, there is an option like Insufficient Lake Formation. Note, it takes 2 business days to complete since is a manual process performed by the engineers. You can check the [Important Guidelines] reading before the lab about this issue. Hope it helps

Hello @Georgios , Thanks for the response but sorry it doesn’t help at all actually. I already did this steps based on what I have read on this form. I filled the form 2 days ago and no thing happened ever since. I tried troubleshooting this problem myself by trying to wait 2 hours then try again but that didn’t help either. there is also this weird problem where I got and ALREADYEXIST error for the aws_glue_catalog_database when trying to perform terraform apply on a fresh lab after 2 hours (a session reset), I was only able to bypass this issue by changing “{var.project}-analytics-db" to "{var.project}-analytics-db2” which allowed the terraform apply step to perform as expected. however this didn’t help with the Insufficient Lake Formation permission(s) on dim_customers error when running the etl job.
This is the only activity left for me to be done with this course and it’s so frustrating that I can’t get it done after spending this much time, what a prefect example of the “undifferentiated weight lifting” concept!.

Hello @Ammaro,

Sorry for the inconvenience and the issue you have is something that can be fixed via the form. It might need to resubmit the form since it is performed manually by an engineer. Perhaps a staff @hawraa.salami could check why it didn’t fix your Insufficient Lake Formation issue the first time. Thank you

@Ammaro Your account has been refreshed. We kindly ask our learners to wait for 2 business days.

When you try the lab again, could you please make sure to use again this name “${var.project}-analytics-db” for the glue catalog database?

Hello @hawraa.salami , Thank you so much for your help. I was able to pass the assignment and complete the course! :slight_smile:

2 Likes