Software Alternatives & Reviews

Amazon Athena VS Presto DB

Compare Amazon Athena VS Presto DB and see what are their differences

Amazon Athena logo 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.

Presto DB logo Presto DB

Distributed SQL Query Engine for Big Data (by Facebook)
  • Amazon Athena Landing page
    Landing page //
    2023-03-17
  • Presto DB Landing page
    Landing page //
    2023-03-18

Amazon Athena

Categories
  • Data Analysis
  • ETL
  • Business Intelligence
  • Databases
Website aws.amazon.com
Details $-

Presto DB

Categories
  • Database Tools
  • Data Dashboard
  • Big Data Analytics
  • SQL
  • Big Data Tools
  • Big Data
  • SQL Query Engine
Website prestodb.io
Details $

Amazon Athena videos

AWS Big Data: What is Amazon Athena?

More videos:

  • Review - Deep Dive on Amazon Athena - AWS Online Tech Talks
  • Review - Deep Dive on Amazon Athena - AWS Online Tech Talks

Presto DB videos

No Presto DB videos yet. You could help us improve this page by suggesting one.

+ Add video

Category Popularity

0-100% (relative to Amazon Athena and Presto DB)
Databases
73 73%
27% 27
Data Dashboard
0 0%
100% 100
Database Management
100 100%
0% 0
Database Tools
0 0%
100% 100

User comments

Share your experience with using Amazon Athena and Presto DB. For example, how are they different and which one is better?
Log in or Post with

Social recommendations and mentions

Based on our record, Amazon Athena should be more popular than Presto DB. It has been mentiond 20 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

Amazon Athena mentions (20)

  • Spatial Search of Amazon S3 Express One Zone Data with Amazon Athena and Visualized It in QGIS
    Prepare GIS data for use with Amazon Athena. This time, we created four types of sample data in QGIS in advance. - Source: dev.to / 4 months ago
  • Enhancing AWS Athena Efficiency - Building a Python Athena Client
    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 / 6 months ago
  • Best architecture to provide real time data analytics to users?
    Probably S3 Select or Athena? https://aws.amazon.com/athena/ Both can query S3 directly. Source: 12 months ago
  • How to browse an RDS snapshot that has been exported to S3
    You can use athena to query data out of parquet files in S3. Source: about 1 year ago
  • AWS Beginner's Key Terminologies
    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 / about 1 year ago
View more

Presto DB mentions (6)

  • Parsing logs from multiple data sources with Ahana and Cube
    Presto is an open-source distributed SQL query engine, originally developed at Facebook, now hosted under the Linux Foundation. It connects to multiple databases or other data sources (for example, Amazon S3). We can use a Presto cluster as a single compute engine for an entire data lake. - Source: dev.to / almost 2 years ago
  • Can a data warehouse be skipped?
    Fair point, but I am talking about Athena (not SQL Server), which under the hood uses a distributed query engine. It is capable to deal with huge amounts of data, if the storage is in the right shape. You can read more about the underlying technology here: https://prestodb.io/. Source: about 2 years ago
  • why use Redshift if we can use S3 to store data and can connect with Quicksight for dashboarding?
    So there is Presto, which is a distributed SQL engine created by Facebook. Source: about 2 years ago
  • Understanding AWS Athena 101
    You can use Athena to run data analytics, with just standard SQL (Presto). - Source: dev.to / over 2 years ago
  • ETL tool for query building across multiple databases in Mongo DB
    Presto does this, but I'm honestly uncertain how performant it is. In my experience, centralizing data is the superior approach to attempting to query multiple sources in place. Source: over 2 years ago
View more

What are some alternatives?

When comparing Amazon Athena and Presto DB, you can also consider the following products

phpMyAdmin - phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web.

Looker - Looker makes it easy for analysts to create and curate custom data experiences—so everyone in the business can explore the data that matters to them, in the context that makes it truly meaningful.

SQLyog - Webyog develops MySQL database client tools. Monyog MySQL monitor and SQLyog MySQL GUI & admin are trusted by 2.5 million users across the globe.

Google BigQuery - A fully managed data warehouse for large-scale data analytics.

Toad for Oracle - Toad is an industry-standard tool for application development.

Jupyter - Project Jupyter exists to develop open-source software, open-standards, and services for interactive computing across dozens of programming languages. Ready to get started? Try it in your browser Install the Notebook.