“Big ” is a buzzword in today’s world, and many businesses are looking into how to handle their own big . A common solution for many is cloud-based services. Both of Amazon, Redshift and Athena are tools that have helped build cloud-based warehouse technologies into more interactive, current, and analytical solutions to big problems. While both are great means of analyzing , each has its own advantages and disadvantages, and I wanted to discuss Redshift vs. Athena.

Redshift is a fully managed data warehouse that exists in the cloud. It’s based on PostgreSQL 8.0.2 and is designed to deliver fast query and I/O performance for any size dataset. Athena is an interactive query service that allows you to conveniently analyze data stored in Amazon Simple Storage Service (S3) by using basic SQL. The biggest, most obvious (in my opinion) between the two is that Redshift requires the user to set up collections of servers called clusters. A further breakdown of the differences between Redshift and Athena can be found here.

Source link

No tags for this post.


Please enter your comment!
Please enter your name here