StackShareStackShare
Follow on
StackShare

Discover and share technology stacks from companies around the world.

Product

  • Stacks
  • Tools
  • Companies
  • Feed

Company

  • About
  • Blog
  • Contact

Legal

  • Privacy Policy
  • Terms of Service

© 2025 StackShare. All rights reserved.

API StatusChangelog
Amazon Athena
ByAmazon-mksAmazon-mks

Amazon Athena

#35in Databases
Discussions4
Followers840
OverviewDiscussions4

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 Databases category of a tech stack.

Amazon Athena Pros & Cons

Pros of Amazon Athena

  • ✓Use SQL to analyze CSV files
  • ✓Glue crawlers gives easy Data catalogue
  • ✓Cheap
  • ✓Query all my data without running servers 24x7
  • ✓No data base servers yay
  • ✓Easy integration with QuickSight
  • ✓Also glue and athena use same data catalog
  • ✓Query and analyse CSV,parquet,json files in sql
  • ✓No configuration required
  • ✓Ad hoc checks on data made easy

Cons of Amazon Athena

No cons listed yet.

Amazon Athena Alternatives & Comparisons

What are some alternatives to Amazon Athena?

Apache Spark

Apache Spark

Spark is a fast and general processing engine compatible with Hadoop data. It can run in Hadoop clusters through YARN or Spark's standalone mode, and it can process data in HDFS, HBase, Cassandra, Hive, and any Hadoop InputFormat. It is designed to perform both batch processing (similar to MapReduce) and new workloads like streaming, interactive queries, and machine learning.

Splunk

Splunk

It provides the leading platform for Operational Intelligence. Customers use it to search, monitor, analyze and visualize machine data.

Apache Flink

Apache Flink

Apache Flink is an open source system for fast and versatile data analytics in clusters. Flink supports batch and streaming analytics, in one system. Analytical programs can be written in concise and elegant APIs in Java and Scala.

Apache Hive

Apache Hive

Hive facilitates reading, writing, and managing large datasets residing in distributed storage using SQL. Structure can be projected onto data already in storage.

AWS Glue

AWS Glue

A fully managed extract, transform, and load (ETL) service that makes it easy for customers to prepare and load their data for analytics.

Presto

Presto

Distributed SQL Query Engine for Big Data

Amazon Athena Integrations

Amazon S3, Presto, SQueaLy, strongDM, Redash and 7 more are some of the popular tools that integrate with Amazon Athena. Here's a list of all 12 tools that integrate with Amazon Athena.

Amazon S3
Amazon S3
Presto
Presto
SQueaLy
SQueaLy
strongDM
strongDM
Redash
Redash
AWS Glue
AWS Glue
AWS Data Wrangler
AWS Data Wrangler
AWS Glue DataBrew
AWS Glue DataBrew
Amazon Managed Workflows for Apache Airflow
Amazon Managed Workflows for Apache Airflow
preset.io
preset.io
Thundra
Thundra
MLCraft
MLCraft

Amazon Athena Discussions

Discover why developers choose Amazon Athena. Read real-world technical decisions and stack choices from the StackShare community.

vinaykumar Reddy
vinaykumar Reddy

Apr 14, 2023

Needs adviceonAmazon AthenaAmazon AthenaNode.jsNode.js

Could you please suggest the best database engine for on-premise? We have used Amazon Athena for the cloud. We are looking similar product for on-premise. This should support Node.js programming language.

0 views0
Comments
Raunak Dave
Raunak Dave

Apr 15, 2022

Needs adviceonAmazon S3Amazon S3Amazon DynamoDBAmazon DynamoDBAmazon AthenaAmazon Athena

So, I have data in Amazon S3 as parquet files and I have it available in the Glue data catalog too. I want to build an AppSync API on top of this data. Now the two options that I am considering are:

  1. Bring the data to Amazon DynamoDB and then build my API on top of this Database.

  2. Add a Lambda function that resolves Amazon Athena queries made by AppSync.

Which of the two approaches will be cost effective?

I would really appreciate some back of the envelope estimates too.

Note: I only expect to make read queries. Thanks.

0 views0
Comments
Punith Ganadinni
Punith Ganadinni

Senior Product Engineer

Nov 13, 2020

Needs adviceonAWS GlueAWS GlueAmazon RDSAmazon RDSAmazon S3Amazon S3

Hey all, I need some suggestions in creating a replica of our RDS DB for reporting and analytical purposes. Cost is a major factor. I was thinking of using AWS Glue to move data from Amazon RDS to Amazon S3 and use Amazon Athena to run queries on it. Any other suggestions would be appreciable.

0 views0
Comments
Sung Won Chung
Sung Won Chung

Jun 5, 2019

Needs adviceonAmazon AthenaAmazon AthenaGoogle BigQueryGoogle BigQuery

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.

0 views0
Comments

Try It

Visit Website

Adoption

On StackShare

Companies
183
CSTMPC+177
Developers
324
SLKWAM+318