What is AWS Athena and what is it for?

March 06, 2023

Tags: Technologies



When it comes to trusting a cloud computing platform, AWS, or Amazon Web Services, it is the most requested by experts. This platform includes multiple services that adapt to any function that the technological project needs, in addition to being friendly for the user who is not an expert in technology.


In their official documentation, they define it like this: “Amazon Web Services (AWS) is the most complete and widely adopted cloud platform in the world, offering more than 200 complete data center services worldwide. Millions of customers, including the fastest growing startups, largest enterprises, and top government agencies, use AWS to reduce costs, become more agile, and innovate faster.”





Today's Most Popular AWS Services


There are many popular services offered by AWS (Amazon Web Services), and the popularity of each service can vary by use case and industry. However, some of the most widely used AWS services are:


  • Amazon EC2 (Elastic Compute Cloud): Provides scalable computing capacity in the cloud, allowing users to launch virtual machines and run applications.
  • Amazon S3 (Simple Storage Service): Provides highly scalable and durable object storage for any type of data, such as images, videos, and documents.
  • Amazon RDS (Relational Database Service): Provides a managed database service that makes it easy to set up, operate, and scale a relational database in the cloud.
  • Amazon Lambda: A serverless computing service that allows users to run code without provisioning or managing servers, making it ideal for event-based computing and real-time data processing.
  • Amazon CloudFront: A content delivery network (CDN) that accelerates the delivery of static and dynamic web content such as images, videos, and APIs.
  • Amazon Route 53: A highly available and scalable Domain Name System (DNS) service that helps users route Internet traffic to their web applications.
  • Amazon DynamoDB: A fully managed NoSQL database service that provides fast, predictable performance with seamless scalability.
  • Amazon SNS (Simple Notification Service): A messaging service that enables push notifications to be sent to mobile devices, email, and other endpoints.
  • Amazon SQS (Simple Queue Service): A fully managed message queuing service that enables you to decouple and scale microservices, distributed systems, and serverless applications.
  • Amazon Elastic Beanstalk: A fully managed service that makes it easy to deploy and manage web applications using popular programming languages such as Java, .NET, PHP, Python, and Node.js.


These are just a few examples of the most widely used AWS services. AWS offers a wide range of services that can meet a variety of computing needs, including AI/ML, security, analytics, and more.




What is AWS Athena?


AWS Athena is a serverless, interactive query service that allows users to analyze data stored in Amazon S3 using SQL. With Athena, users can easily query data in S3 without having to set up or manage any infrastructure.


Athena is designed to work with a variety of data formats, including CSV, JSON, ORC, Parquet, and Avro. Users can also create custom data connectors to support additional data formats.


To use Athena, users simply create a database and table schema that maps to data stored in S3. They can then run ad hoc SQL queries against the data using the Athena Query Editor or any other SQL client that supports JDBC/ODBC drivers.


Athena automatically scales to handle large data sets and can process queries in parallel to deliver fast results. Users only pay for the queries they run, and there are no upfront costs or infrastructure to manage.


Athena is commonly used for ad hoc data exploration, data lake analysis, log analysis, and business intelligence reporting. It integrates with a variety of AWS services, including Amazon QuickSight, AWS Glue, AWS Lambda, and Amazon EMR.


At Rootstack we have used several AWS services for projects with our international clients, always yielding successful results. During a DevOps and QA service to a Latin American bank, Confluence, AWS, S3, Cloudfront, Docker, ECS, EKS, EC2, Load Balancer, Cloudwatch were used.


Contact us and our experts will immediately establish a pleasant and detailed communication where they will explain each of our services and the benefits they offer for your company, employees and also for your clients.


We recommend you on video