Amazon Athena or Redshift Spectrum

0 votes

Which to choose among Amazon Athena and Amazon Redshift?

Nov 26, 2018 in AWS by datageek
• 3,090 points

1 answer to this question.

0 votes

Amazon Athena is the simplest way to give any employee the ability to run ad-hoc queries on data in Amazon S3. Athena is serverless, so there is no infrastructure to setup 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.

answered Nov 26, 2018 by Archana
• 5,640 points

Related Questions In AWS

0 votes
1 answer

Amazon Athena vs Amazon Redshift

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

answered Sep 27, 2018 in AWS by Archana
• 4,150 points
+4 votes
5 answers

Usage of Amazon Cloudfront or S3

When to use S3? S3 is like many ...READ MORE

answered Apr 3, 2018 in AWS by brat_1
• 7,200 points
0 votes
1 answer

How can I install curl 7.34 or later on Amazon linux old instance

got answer from this link worked for ...READ MORE

answered Aug 9, 2018 in AWS by Priyaj
• 58,140 points
0 votes
1 answer
+1 vote
2 answers
0 votes
1 answer

How does Amazon Redshift keep data secure?

Amazon Redshift encrypts and keeps your data ...READ MORE

answered Nov 6, 2018 in AWS by Archana
• 5,640 points
0 votes
1 answer

How to execute scheduled SQL scripts in on Amazon Redshift?

I had faced the same problem earlier. ...READ MORE

answered Nov 19, 2018 in AWS by Archana
• 5,640 points