Insufficient Lake Formation permission(s) on mock_data_patient (Database name: crawl_db, Table Name: mock_data_patient)

Question

Crawler Error:

Insufficient Lake Formation permission(s) on mock_data_patient (Database name: crawl_db, Table Name: mock_data_patient)

0

Crawler Error:

Insufficient Lake Formation permission(s) on mock_data_patient (Database name: crawl_db, Table Name: mock_data_patient) (Service: AWSGlue; Status Code: 400; Error Code: AccessDeniedException; Request ID: 1be12bc2-fa92-4f5f-87c8-1d1508399349; Proxy: null). For more information, see Setting up IAM Permissions in the Developer Guide (http://docs.aws.amazon.com/glue/latest/dg/getting-started-access.html).

I'm facing this issue on a Free Tier Account.

Accepted Answer

That means the database is managed by LF and the crawler role doesn't have permission to create/update tables on that database.  
Go to LakeFormation and in "Data lake permissions" grant permissions to the role

Insufficient Lake Formation permission(s) on mock_data_patient (Database name: crawl_db, Table Name: mock_data_patient)

Contenuto pertinente