In our organization, we facing cost issues due to overload of S3 buckets. Too many junk files and archives are stored which are causing this issue.

I recently got an approval to work on Lifecycle policy in AWS S3. Before I start to work on this, I need to clarify that our Athena databases have their storage in one of the S3 buckets.

If we change the storage class, will that impact the Athena database queries?

CodePudding user response：

That depends on the storage class.

If you archive data into Glacier, Athena won't be able to read it and just ignores it. For the other storage classes, e.g. the infrequently accessed ones Athena can still read them, but your costs will increase if they're read at least once per month.