CODEWITHSUNDEEP
sqlamazon-athena
Ankan
Ankan

Reputation: 21

How is AWS Athena so different from a database

AWS Athena can read tables, create new tables and insert into tables (among other things). Is it fair to say that Athena can replace the basic functions of a database , or is it fair to say that Athena can be seen as a lightweight serverless replacement of a relational DB? What are its major differences compared to a DB ?

Upvotes: 2

Views: 1022

Answers (1)

Prabhakar Reddy
Prabhakar Reddy

Reputation: 5144

Athena is not a database and it's a query engine.In Athena compute and storage are separate where as in the case of a database both are tightly coupled.

Athena is more of a OLAP solution where as relational DB is OLTP and it is fully managed service. It will also not maintain the metadata and instead use Glue catalog to store and reteive it.

Also found this article which talks little more about the differences. You can have a read.

Upvotes: 3

Related Questions