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,540 points
974 views

1 answer to this question.

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
• 4,170 points

Related Questions In AWS

0 votes
2 answers

Loading data (incrementally) into Amazon Redshift, S3 vs DynamoDB vs Insert

It is achievable to aggregate event logs ...READ MORE

answered Feb 9, 2022 in AWS by anonymous
1,216 views
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
• 58,020 points
10,850 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,640 points
1,054 views
0 votes
1 answer
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
• 4,170 points
7,560 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
• 4,170 points
780 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP