By using AWS re:Post, you agree to the AWS re:Post Terms of Use
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.

Topics
AnalyticsCloud Financial Management
Tags
Amazon AthenaAWS Cost and Usage Report
Language
English
Ramu Varanasi
asked a year ago760 views
1 Answer
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
answered a year ago

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

Relevant content