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
asked a year ago527 views
1 Answer
1
Accepted Answer

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
EXPERT
answered a year ago
  • The issue was that, the when the lake formation has created the datalake location, the role was not assigned to AWSServiceRoleForLakeFormationDataAccess

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