Here's all you need to know:

Amazon Athena is an interactive query service that lets you simply analyze data in Amazon S3 storage using standard SQL.
Athena is a serverless service, so there is no architecture to manage, and you are only charged for queries executed.

Athena service is very easy to use.
Just specify the data in Amazon S3, set the schema, and run the queries using standard SQL tools. In this way, any professional with knowledge of SQL can quickly analyze large amounts of data.

What is Amazon Athena used for?

Overall, the interactive query service is an analytical tool that helps organizations analyze data stored in Amazon S3. Amazon Athena can process unstructured, semistructured and structured data sets.

What features does Amazon Athena have?

Touted features of Amazon Athena include: no server to manage, easy SQL querying, integrations, federated queries, security, machine learning.

What are the benefits of Amazon Athena?
Benefits of Amazon Athena include:

1️⃣ Serverless.
There is no need to manage any underlying compute infrastructure to use the tool.

2️⃣ SQL-based.
Users can run SQL queries using Presto. The query engine is open source and optimized for data analysis.

3️⃣ Organizations only pay for data scanned.
Pay only for queries that are run. Query costs are $5 per terabyte scanned.

4️⃣ Speed.
Queries are executed in parallel for large data sets, making complex queries fast.

5️⃣ An open architecture.
Users are not limited to AWS-specific software, avoiding vendor lock-in.

6️⃣ Flexibility.
Users can run multiple queries simultaneously.

In this post, we have understood the benefits of using cloud computing tools like AWS Athena and the underlying concepts of using the tool. Athena is serverless which means it is easily scalable depending on the load of the system.

With Amazon, it's always fast and reliable.
    Made on