Amazon Athena vs Amazon Redshift

0 votes
I am new to AWS Cloud. I was looking into database services & couldn't figure out when to use Amazon Athena and when to use Amazon Redshift. A simple answer would suffice.
Sep 27, 2018 in AWS by datageek
• 2,390 points
62 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

"Amazon Athena is the simplest way to give an employee the ability to run ad-hoc queries on data in Amazon S3. Athena is serverless, so there is no infrastructure to set up or manage, and you can start analyzing your data immediately.

If you have frequently accessed data, that needs to be stored in a consistent, highly structured format, then you should use a data warehouse like Amazon Redshift. This gives you the flexibility to store your structured, frequently accessed data in Amazon Redshift, and use Redshift Spectrum to extend your Amazon Redshift queries out to the entire universe of data in your Amazon S3 data lake. This gives you the freedom to store your data where you want, in the format you want, and have it available for processing when you need. "

This is from AWS FAQ's

answered Sep 27, 2018 by Archana
• 3,770 points

Related Questions In AWS

0 votes
1 answer
0 votes
1 answer

Error in Adding LIMIT fixes “Invalid digit, Value N” in Amazon Redshift.

This could be expressed simply as: SELECT TOP ...READ MORE

answered Sep 4, 2018 in AWS by Priyaj
• 56,100 points
914 views
0 votes
1 answer

Custom authorizer vs Cognito - authentication for amazon api gateway - Web application

okay, authentication and security is indeed hard ...READ MORE

answered Sep 24, 2018 in AWS by Priyaj
• 56,100 points
383 views
0 votes
1 answer

Amazon Athena or Redshift Spectrum?

Amazon Athena is the simplest way to give ...READ MORE

answered Nov 26, 2018 in AWS by Archana
• 5,280 points
128 views
0 votes
1 answer
0 votes
1 answer

How to connect Amazon RedShift in Apache Spark?

It turns out you just need a ...READ MORE

answered Aug 22, 2018 in AWS by Archana
• 3,770 points
771 views
0 votes
1 answer

Scaling in Amazon Redshift

The existing data warehouse cluster remains available ...READ MORE

answered Sep 27, 2018 in AWS by Archana
• 3,770 points
15 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.