When running the jobs for the transformation scripts, I get the following error:
AnalysisException: Insufficient Lake Formation permission(s) on de_c4w4a1_silver_db (Service: AWSGlue; Status Code: 400; Error Code: AccessDeniedException; Request ID: adbaaaa1-4e10-4068-a273-d752b3ea5889; Proxy: null)
I also have insufficient permissions when trying to execute the sql statements:
%sql select * from deftunes_transform.songs limit 10
(psycopg2.errors.InternalError_) AwsClientException: AccessDeniedException from glue - Resource does not exist or requester is not authorized to access requested permissions.
[SQL: select * from deftunes_transform.songs limit 10]
(Background on this error at: Error Messages — SQLAlchemy 1.4 Documentation)
My AWS was refreshed today, and now I was finally able to deploy all the terraform code without any error, and now I get this. Is there a way to give my account the proper permissions without having the refresh it again? I really do not want to do this lab all over again for the third time, all I am missing is to simply execute the cells so I can get the proper output for the grading. This is the only thing keeping me from finishing this course and getting my certificate.