Amazon Athena vs Amazon Redshift Spectrum: What are the differences?
Amazon Athena: Query S3 Using SQL. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run; Amazon Redshift Spectrum: Exabyte-Scale In-Place Queries of S3 Data. With Redshift Spectrum, you can extend the analytic power of Amazon Redshift beyond data stored on local disks in your data warehouse to query vast amounts of unstructured data in your Amazon S3 “data lake” -- without having to load or transform any data.
Amazon Athena and Amazon Redshift Spectrum can be primarily classified as "Big Data" tools.
According to the StackShare community, Amazon Athena has a broader approval, being mentioned in 50 company stacks & 18 developers stacks; compared to Amazon Redshift Spectrum, which is listed in 5 company stacks and 4 developer stacks.