C4W4A4 Capstone Part 2: Insufficient Lake Formation permission(s) on de_c4w4a2_silver_db

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

C4W4A4
assignment-5-capstone-project-part-2-data-quality-and-orchestration-and

Regarding the issue:

Both transformation jobs are failing due to the following error:

Insufficient Lake Formation permission(s) on de_c4w4a2_silver_db

It appears that the AWS Glue role doesn’t have the required permissions to access the de_c4w4a2_silver_db database.

I attempted to manually set the permissions but don’t have access to modify them.

I’ve submitted the permissions request form and included vocapi_logger in the submission.

2

Hello @wesly_i_castro
If you have already filled out the lab refresh form, please wait for 3 business days and try again after.

3

I’m running into the same issue. Yesterday, I was able to execute all of part 1 of the lab, which included the transform jobs. Based on other user queries here, it sounds like the only thing to do is to submit a form to have my permissions reset?

4

Found the original thread I replied to! It looks like no one has looked at it, though I submitted the lab refresh form 5 days ago. Help? Thanks! @Amir_Zare

5

Well, I just tried again, for fun, and I’m no longer getting the error. I notice the API endpoint was changed when I looked in the CloudFormation stack outputs.