Need advice about which tool to choose?Ask the StackShare community!

Amazon Athena

505
839
+ 1
49
Amazon RDS

16.1K
10.8K
+ 1
761
Add tool

Amazon Athena vs Amazon RDS: What are the differences?

Amazon Athena: Query S3 Using SQL. 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 RDS: Set up, operate, and scale a relational database in the cloud. Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle or Microsoft SQL Server database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your Database Instance (DB Instance) via a single API call.

Amazon Athena and Amazon RDS are primarily classified as "Big Data" and "SQL Database as a Service" tools respectively.

"Use SQL to analyze CSV files" is the top reason why over 13 developers like Amazon Athena, while over 162 developers mention "Reliable failovers" as the leading cause for choosing Amazon RDS.

Airbnb, Netflix, and Amazon are some of the popular companies that use Amazon RDS, whereas Amazon Athena is used by CRED, Bagelcode, and Queue-it. Amazon RDS has a broader approval, being mentioned in 2499 company stacks & 8078 developers stacks; compared to Amazon Athena, which is listed in 124 company stacks and 197 developer stacks.

Manage your open source components, licenses, and vulnerabilities
Learn More
Pros of Amazon Athena
Pros of Amazon RDS
  • 16
    Use SQL to analyze CSV files
  • 8
    Glue crawlers gives easy Data catalogue
  • 7
    Cheap
  • 6
    Query all my data without running servers 24x7
  • 4
    No data base servers yay
  • 3
    Easy integration with QuickSight
  • 2
    Query and analyse CSV,parquet,json files in sql
  • 2
    Also glue and athena use same data catalog
  • 1
    No configuration required
  • 0
    Ad hoc checks on data made easy
  • 165
    Reliable failovers
  • 156
    Automated backups
  • 130
    Backed by amazon
  • 92
    Db snapshots
  • 87
    Multi-availability
  • 30
    Control iops, fast restore to point of time
  • 28
    Security
  • 24
    Elastic
  • 20
    Push-button scaling
  • 20
    Automatic software patching
  • 4
    Replication
  • 3
    Reliable
  • 2
    Isolation

Sign up to add or upvote prosMake informed product decisions

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.

What is Amazon RDS?

Amazon RDS gives you access to the capabilities of a familiar MySQL, Oracle or Microsoft SQL Server database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with Amazon RDS. Amazon RDS automatically patches the database software and backs up your database, storing the backups for a user-defined retention period and enabling point-in-time recovery. You benefit from the flexibility of being able to scale the compute resources or storage capacity associated with your Database Instance (DB Instance) via a single API call.

Need advice about which tool to choose?Ask the StackShare community!

What companies use Amazon Athena?
What companies use Amazon RDS?
Manage your open source components, licenses, and vulnerabilities
Learn More

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Amazon Athena?
What tools integrate with Amazon RDS?

Sign up to get full access to all the tool integrationsMake informed product decisions

Blog Posts

Aug 28 2019 at 3:10AM

Segment

PythonJavaAmazon S3+16
7
2758
Jul 2 2019 at 9:34PM

Segment

Google AnalyticsAmazon S3New Relic+25
10
7015
GitHubDockerAmazon EC2+23
12
6753
JavaScriptGitHubPython+42
53
22491
DockerSlackAmazon EC2+17
18
6132
What are some alternatives to Amazon Athena and Amazon RDS?
Presto
Distributed SQL Query Engine for Big Data
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