258
326
+ 1
43

What is Amazon Athena?

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.
Amazon Athena is a tool in the Big Data Tools category of a tech stack.

Who uses Amazon Athena?

Companies
96 companies reportedly use Amazon Athena in their tech stacks, including Queue-it, Doubtnut, and Bagelcode.

Developers
153 developers on StackShare have stated that they use Amazon Athena.

Amazon Athena Integrations

Amazon S3, Presto, AWS Glue, Redash, and Cube.js are some of the popular tools that integrate with Amazon Athena. Here's a list of all 10 tools that integrate with Amazon Athena.
Private Decisions at about Amazon Athena

Here are some stack decisions, common use cases and reviews by members of with Amazon Athena in their tech stack.

I use Amazon Athena because similar to Google BigQuery , you can store and query data easily. Especially since you can define data schema in the Glue data catalog, there's a central way to define data models.

However, I would not recommend for batch jobs. I typically use this to check intermediary datasets in data engineering workloads. It's good for getting a look and feel of the data along its ETL journey.

See more

Hi all,

Currently, we need to ingest the data from Amazon S3 to DB either Amazon Athena or Amazon Redshift. But the problem with the data is, it is in .PSV (pipe separated values) format and the size is also above 200 GB. The query performance of the timeout in Athena/Redshift is not up to the mark, too slow while compared to Google BigQuery. How would I optimize the performance and query result time? Can anyone please help me out?

See more
Public Decisions about Amazon Athena

Here are some stack decisions, common use cases and reviews by companies and developers who chose Amazon Athena in their tech stack.

I use Amazon Athena because similar to Google BigQuery , you can store and query data easily. Especially since you can define data schema in the Glue data catalog, there's a central way to define data models.

However, I would not recommend for batch jobs. I typically use this to check intermediary datasets in data engineering workloads. It's good for getting a look and feel of the data along its ETL journey.

See more

Hi all,

Currently, we need to ingest the data from Amazon S3 to DB either Amazon Athena or Amazon Redshift. But the problem with the data is, it is in .PSV (pipe separated values) format and the size is also above 200 GB. The query performance of the timeout in Athena/Redshift is not up to the mark, too slow while compared to Google BigQuery. How would I optimize the performance and query result time? Can anyone please help me out?

See more

Amazon Athena Alternatives & Comparisons

What are some alternatives to Amazon Athena?
Presto
Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
Amazon Redshift Spectrum
With Redshift Spectrum, you can extend the analytic power of Amazon Redshift beyond data stored on local disks in your data warehouse to query vast amounts of unstructured data in your Amazon S3 “data lake” -- without having to load or transform any data.
Amazon Redshift
It is optimized for data sets ranging from a few hundred gigabytes to a petabyte or more and costs less than $1,000 per terabyte per year, a tenth the cost of most traditional data warehousing solutions.
Cassandra
Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
Spectrum
The community platform for the future.
See all alternatives

Amazon Athena's Followers
326 developers follow Amazon Athena to keep up with related blogs and decisions.
Lien Daniel
Carlos Pereda
taniya bose
Francisco Antonio Torres Jackson
Aman Grover
George Rose
Drooy Drooy
Weird Weird
si downes
Alex Stec