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
posta un anno fa558 visualizzazioni
1 Risposta
1
Risposta accettata

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
ESPERTO
con risposta un anno fa
  • The issue was that, the when the lake formation has created the datalake location, the role was not assigned to AWSServiceRoleForLakeFormationDataAccess

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande