En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

Amazon Athena ALTER TABLE query for Load Partitions throwing Permission Error

0

Hi All,

I am getting permission error while running the alter table - load partitions from a partitioned cur report table- query on Amazon Athena. [ErrorCategory:USER_ERROR, ErrorCode:PERMISSION_ERROR], Detail:Amazon Athena experienced a permission error. Please provide proper permission and submitting the query again.

Can anyone suggest a solution for this. Thanks.

Sujets
AnalytiqueCloud Financial Management
Balises
Amazon AthenaRapport Coût et utilisation de AWS
Langue
English
Ramu Varanasi
demandé il y a 2 ans999 vues
1 réponse
1

The most efficient way to assist your specific issue would be for you to open a technical support case and include the Athena Error and Execution ID from the Athena History (recent queries). This will enable the support folks to dive deep into the error you received.

Alternatively, I did find a document that states the Glue permissions [1] needed to alter an Athena Table. However, there are a number of services involved and the support folks can help you identify the specific permissions you are missing.

[1] https://docs.aws.amazon.com/athena/latest/ug/fine-grained-access-to-glue-resources.html

profile pictureAWS
EXPERT
Shlomo Dubrowin
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents