Athena + s3 Intelligent Tiering storage class


If I have an athena table built on top of a s3 bucket whose objects are in the intelligent tiering storage class, is there anything to keep in mind? Will it still work?

asked 9 months ago754 views
1 Answer
Accepted Answer

Amazon Athena works by querying data directly from Amazon S3, and it can query data regardless of its storage class. If your data is stored in the S3 Intelligent-Tiering storage class, Athena can still query it. However, there are a few things to keep in mind:

- Performance: The S3 Intelligent-Tiering storage class is designed to optimize costs for data with changing or unknown access patterns. It moves objects between two access tiers (frequent and infrequent access) based on changing access patterns. If your data is in the infrequent access tier when you query with Athena, there might be a slight latency overhead compared to the standard storage class.

- Retrieval Costs: While the S3 Intelligent-Tiering storage class does not have retrieval fees for objects in the frequent access tier, there are retrieval fees for objects in the infrequent access tier. If you're querying data in Athena that resides in the infrequent access tier, you'll incur these retrieval costs. This is in addition to the Athena query costs.

- Monitoring: It's a good practice to monitor your S3 usage and costs. The S3 Intelligent-Tiering storage class automatically moves objects between the two tiers based on access patterns. You can use Amazon S3 analytics to monitor the access patterns of your data and ensure that Intelligent-Tiering is cost-effective for your use case.

- Data Lifecycle: If you have set up lifecycle policies on your S3 bucket, be aware of how they impact your data, especially if data is transitioned to other storage classes or expired/deleted.

- Partitioning & Data Organization: This isn't specific to the Intelligent-Tiering storage class but is general advice for using Athena with S3. Organizing your data efficiently, using partitioning, and compressing your data can significantly improve performance and reduce costs.

In conclusion, yes, Athena will work with data stored in the S3 Intelligent-Tiering storage class. Just be aware of potential performance implications and additional costs for accessing data in the infrequent tier. As always, monitor usage and costs to ensure you're getting the desired performance and value.

profile picture
answered 9 months ago
profile pictureAWS
reviewed 9 months ago
  • thanks for the detailed answer

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