I received below error in one of Blueprint jobs :
An error occurred while calling o452.getDynamicFrame. ERROR: permission denied for table tmp_company
I found below errors in the error log of the job:
py4j.protocol.Py4JJavaError: An error occurred while calling o452.getDynamicFrame.
org.postgresql.util.PSQLException: ERROR: permission denied for table tmp_company
I already granted super permission to the lake formation role on the lake formation database!
also lake formation admin user has all sufficient permissions!!
The error in one job only and the other jobs finished successfully!!
Any clue??
