What permissions configurations are required on an S3 bucket for Athena to be able to Preview View on an object?

Question

Hello, I've been able to create tables and various views in Athena console after running a Glue crawler against an S3 bucket as a datasource.

When running a Preview View from Athena on a view generated from the Glue crawler, I am getting an error with some reference to a Hive split on a CSV file in our S3 bucket similar to the following:

`Error opening Hive split s3://bucket_name/Folder1/folder/File.csv (offset=33554432, length=33554432) using org.apache.hadoop.mapred.TextInputFormat: Permission denied on S3 path: s3://bucket_name/Folder1/folder/File.csv
This query ran against the "athena_database_name" database, unless qualified by the query. Please post the error message on our forum
or contact customer support with Query Id: e9d6e300-c82d-40d0-b9a0-879e97f72db6`

It is similar to the issue outlined in : 
https://stackoverflow.com/questions/68859517/amazon-athena-error-opening-hive-split-s3-path-and-access-denied

I do not think that this is a permission related to my IAM user but I am unsure what the Hive split is related to. Is this service related? 
If anyone has a solution for this, please let me know.

Thank you in advance.

- M

Answer

Although not exactly similar to the error you are getting, maybe compare your IAM permissions with this checklist https://aws.amazon.com/premiumsupport/knowledge-center/access-denied-athena/

What permissions configurations are required on an S3 bucket for Athena to be able to Preview View on an object?

Relevanter Inhalt