Table of contents
Serverless
Athena is serverless, which means there's no need to set up or manage any infrastructure. You can start querying data immediately without worrying about managing underlying servers.
Pay-as-you-go
You only pay for the queries you run, and the cost is based on the amount of data scanned by the queries. This is cost-effective, especially for infrequent querying.
Scalable
Athena scales automatically, enabling it to handle large datasets and concurrent queries efficiently, without manual intervention.
Integration with AWS ecosystem
Athena integrates seamlessly with other AWS services like S3, Glue, and QuickSight, making it easy to build comprehensive data pipelines and analytics solutions.
Supports standard SQL
Athena uses standard SQL for querying, which makes it easy for users familiar with SQL to get started quickly.
Quick to deploy
Since there is no infrastructure to manage, you can start querying your data within minutes of setting up Athena.
Supports a variety of data formats
Athena supports multiple data formats including CSV, JSON, ORC, Avro, and Parquet, providing flexibility in data ingestion and storage.
Promote Amazon Athena. You can add any of these badges on your website.
Amazon Athena is a powerful and flexible tool for users who need a cost-effective, straightforward solution for querying and analyzing data stored in S3 without the overhead of managing servers. Its serverless architecture, scalability, and wide integration with other AWS services make it a reliable choice for quick data analytics tasks.
We have collected here some useful links to help you find out if Amazon Athena is good.
Check the traffic stats of Amazon Athena on SimilarWeb. The key metrics to look for are: monthly visits, average visit duration, pages per visit, and traffic by country. Moreoever, check the traffic sources. For example "Direct" traffic is a good sign.
Check the "Domain Rating" of Amazon Athena on Ahrefs. The domain rating is a measure of the strength of a website's backlink profile on a scale from 0 to 100. It shows the strength of Amazon Athena's backlink profile compared to the other websites. In most cases a domain rating of 60+ is considered good and 70+ is considered very good.
Check the "Domain Authority" of Amazon Athena on MOZ. A website's domain authority (DA) is a search engine ranking score that predicts how well a website will rank on search engine result pages (SERPs). It is based on a 100-point logarithmic scale, with higher scores corresponding to a greater likelihood of ranking. This is another useful metric to check if a website is good.
The latest comments about Amazon Athena on Reddit. This can help you find out how popualr the product is and what people think about it.
Logs from AWS CloudTrail, Entra ID, Datadog, and Amazon Athena are aggregated and searchable via APIs and CLI commands. LayerX stores logs in Snowflake, making it easy to visualize and retrieve audit evidence. Log extraction is automated—no more ad hoc queries or manual exports. - Source: dev.to / 3 months ago
In this article, we present an architecture that demonstrates how to collect application logs from Amazon Elastic Kubernetes Service (Amazon EKS) via Vector, store them in Amazon Simple Storage Service (Amazon S3) for long-term retention, and finally query these logs using AWS Glue and Amazon Athena. - Source: dev.to / 5 months ago
However, Iceberg defines the storage format, leaving the complexities of data ingestion and processing, especially for real-time streams, to separate systems. While query engines like Trino or Athena excel with static datasets, they aren't designed for continuous, low-latency ingestion and transformation of streaming data into Iceberg. This often forces engineers to integrate multiple complex tools, increasing... - Source: dev.to / 6 months ago
SageMaker Feature Store keeps track of the metadata of stored features (e.g. Feature name or version number) so that you can query the features for the right attributes in batches or in real time using Amazon Athena , an interactive query service. - Source: dev.to / 11 months ago
Prepare GIS data for use with Amazon Athena. This time, we created four types of sample data in QGIS in advance. - Source: dev.to / almost 2 years ago
If you have not heard about AWS Athena, I encourage you to take a look at this service. You can read more about it here. - Source: dev.to / almost 2 years ago
Probably S3 Select or Athena? https://aws.amazon.com/athena/ Both can query S3 directly. Source: over 2 years ago
You can use athena to query data out of parquet files in S3. Source: over 2 years ago
Amazon Athena (analytics) Amazon Athena is an interactive query service that you can use to analyze data in Amazon S3 using ANSI SQL. Athena is serverless, so there's no infrastructure to manage. Athena scales automatically and is simple to use, so you can start analyzing your datasets within seconds. Https://aws.amazon.com/athena/. - Source: dev.to / over 2 years ago
Other systems either use SQL databases for this purpose, or multi-step pipelines that use different tools for storing and querying the data. I didn't want to use either solution, on the one hand, because I didn't find free solutions for low traffic, and on the other the hand because I anyway wanted to experiment a bit with DynamoDB. - Source: dev.to / almost 3 years ago
Once it's in a Data Lake then you have different options depending on the analytics you need. For more advanced constant analytics then you could look into Amazon Kinesis Data Analytics instead of Firehose to S3, but for Ad-Hoc queries then this is where Glue and Athena come in. - Source: dev.to / almost 3 years ago
You will want to use metrics based on operations outcomes to gain useful insights. Now you want to do analytics on your logs and use Cloudwatch Logs Insights or store the logs in Amazon S3, which then triggers an AWS Glue crawler to create an AWS Glue Data Catalog that then can be queried using Amazon Athena using standard SQL. The results can be visualized in Amazon Quicksight. - Source: dev.to / almost 3 years ago
Storing data in S3 has an additional benefit, given how well it integrates with other AWS services. For instance, you can use Amazon Athena to query your S3 data, or Amazon Rekognition to analyze it. Additionally you can use AWS Glue to perform extract, transform, and loan (ETL) operations. To create ad hoc visualizations and business analysis reports, Amazon QuickSight can connect to your S3 buckets and produce... - Source: dev.to / about 3 years ago
> attempting to square-peg-round-hole something like this into AWS S3 I don't think it's like that. AWS already offers services like S3 Select[0] or Athena[1] that do something similar. > the user is merely invited to retry Another reason why I used s3fs instead of manually making requests. > Why not just use the right tool for the job? I certainly have multiple uses-cases where creating an SQLite database locally... - Source: Hacker News / about 3 years ago
It came up with the idea of how to combine Data Engineering with Cloud and automation. I needed to find a data source as it would be an automated pipeline, so I needed a dynamic source. At the same time, I wanted to find a site where I thought retrieving data would not be a problem and do practice with both rvest and dplyr. After I had no problems with my experiments with Carvago, I added the necessary data... - Source: dev.to / about 3 years ago
In this second part, I'm going to show you basic steps on how to run analysis on the extracted grocery data. AWS services we are going to use are AWS Athena and Amazon Quicksight. - Source: dev.to / about 3 years ago
When debating the database solution for our application we were really seeking for a scalable serverless database that wouldn’t bill us for idle time. Options like AWS Athena, AWS Aurora Serverless, and Azure Cosmos DB immediately came to mind. We believed that GCP would have a comparable service, yet we could not find one. Even after consulting the GCP cloud service comparison documentation we were still unable... - Source: dev.to / about 3 years ago
Amazon Web Services, including Athena, Aurora, and Redshift. You may perform benchmarks or comparative tests or evaluations (each, a “Benchmark”) of the Services. If you perform or disclose, or direct or permit any third party to perform or disclose, any Benchmark of any of the Services, you (i) will include in any disclosure, and will disclose to us, all information necessary to replicate such Benchmark, and (ii)... - Source: dev.to / over 3 years ago
Prepare GIS data for use with Amazon Athena. This time, we created four types of sample data in QGIS in advance. - Source: dev.to / over 3 years ago
Once the Cloudflare request logs are in S3, they can be queried using Athena. This blog post even provides a nice CREATE TABLE command to set up the table in Athena. - Source: dev.to / over 3 years ago
Query my datalake with AWS Athena all within Koop and Node. - Source: dev.to / over 3 years ago
Do you know an article comparing Amazon Athena to other products?
Suggest a link to a post with product alternatives.
Is Amazon Athena good? This is an informative page that will help you find out. Moreover, you can review and discuss Amazon Athena here. The primary details have not been verified within the last quarter, and they might be outdated. If you think we are missing something, please use the means on this page to comment or suggest changes. All reviews and comments are highly encouranged and appreciated as they help everyone in the community to make an informed choice. Please always be kind and objective when evaluating a product and sharing your opinion.
