Athena query catalogue / table to access to S3 data

0

Hi

I have a data in S3 which is exposed from Glue Catalogue with a table. The Athena gives the following error when accessing this table.

HIVE_UNKNOWN_ERROR: com.amazonaws.services.lakeformation.model.InvalidInputException: Unable to assume role. Please verify Lake Formation has access to role arn:aws:iam::289301669695:role/aws-reserved/sso.amazonaws.com/eu-central-1/AWSReservedSSO_Admin_d6ea6773e5ad46b6 (Service: AWSLakeFormation; Status Code: 400; Error Code: InvalidInputException; Request ID: 93e11aa6-46e2-47bb-be99-4dddbc7bb820; Proxy: null)

Please note:

  • My user is AWSReservedSSO_Admin_d6ea6773e5ad46b6 with admin/all access granted to access all resources (IAM policy = allow all resources) S3
  • The catalogue table definition is here. Catalogue
  • The following grants are provided Permissions
질문됨 일 년 전559회 조회
1개 답변
1
수락된 답변

There appears to be a problem with the IAM role in Lake Formation.
Make sure you have the necessary permissions as described in the following document.
https://docs.aws.amazon.com/lake-formation/latest/dg/service-linked-roles.html

profile picture
전문가
답변함 일 년 전
  • The issue was that, the when the lake formation has created the datalake location, the role was not assigned to AWSServiceRoleForLakeFormationDataAccess

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠