Need advice about which tool to choose?Ask the StackShare community!
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.
Pros of Amazon Athena
- Use SQL to analyze CSV files16
- Glue crawlers gives easy Data catalogue8
- Cheap7
- Query all my data without running servers 24x76
- No data base servers yay4
- Easy integration with QuickSight3
- Query and analyse CSV,parquet,json files in sql2
- Also glue and athena use same data catalog2
- No configuration required1
- Ad hoc checks on data made easy0
Pros of Amazon RDS
- Reliable failovers165
- Automated backups156
- Backed by amazon130
- Db snapshots92
- Multi-availability87
- Control iops, fast restore to point of time30
- Security28
- Elastic24
- Push-button scaling20
- Automatic software patching20
- Replication4
- Reliable3
- Isolation2