AWS Glue Crawler not creating table

0

Hi I'm creating a table with a crawler but when I run it does it succesfully but when I checked the tables isn't appearing even when in the crawler Table changes from last run appears table created. Help please I have 2 days with that changing the AIM rol permissions

  • Where is not appearing, LF, Glue page, Athena, etc?, how does that relate with "changing AIM role permissions"?

  • Gonzalo I run the crawler but the table doesn't appear in tables and also not appearing in database

  • Gonzalo I run the crawler but the table doesn't appear in tables and also not appearing in database

asked 7 months ago301 views
1 Answer
1

Check the IAM role associated with the crawler. Most likely you don't have correct permission.

When you create the crawler, if you choose to create an IAM role(the default setting), then it will create a policy for S3 object you specified only. if later you edit the crawler and change the S3 path only. The role associated with the crawler won't have permission to the new S3 path.

Sometimes, deleting old role and edit the crawler to create new one would help too

AWS
answered 7 months ago
  • I think it worked but now I have this error below but I talked with the admin of the aws services and he did the steps showed: nsufficient Lake Formation permission(s) on archivoscsv (Database name: aws-glue-lalo-test-crawler, Table Name: archivoscsv) (Service: AWSGlue; Status Code: 400; Error Code: AccessDeniedException; Request ID: 8cd54006-a723-4ea8-809a-9c70308f6fe4; 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).

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions