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
已提問 1 年前檢視次數 558 次
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
專家
已回答 1 年前
  • The issue was that, the when the lake formation has created the datalake location, the role was not assigned to AWSServiceRoleForLakeFormationDataAccess

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南