Amazon Athena allows querying of data from which storage service?

Amazon Athena is specifically designed to interact with data stored in Amazon S3. It is an interactive query service that allows users to analyze vast amounts of data using standard SQL. Since Amazon S3 is an object storage service optimized for scalability and durability, it is ideal for data lakes and large-scale data analytics workflows. Athena enables users to run queries directly against the data in S3 without needing to load the data into a separate database or data warehousing solution.

Other services like Amazon RDS and Amazon EBS serve different purposes; RDS is a managed relational database service, and EBS is block storage. While data can be exported from these services to S3 for analysis, Athena does not natively query data stored in them. On the other hand, Amazon Glacier is a storage service designed for long-term archival and is not designed for querying data in real time, making it unsuitable for use with Athena as well. Thus, the integration of Amazon Athena with Amazon S3 sets the foundation for running SQL queries directly against large datasets efficiently and cost-effectively.