Amazon Redshift Spectrum Vs Athena. An analyst that already works with Redshift will benefit most from Redshift Spectrum because it can quickly access data in the cluster and extend out to infrequently accessed external tables in S3. In Redshift both compute and storage layers are coupled however in Redshift Spectrum compute and storage layers are decoupled. The underlying recommendation for deciding between Athena and Redshift is to start with Athena and move some of the query-intensive use cases to Redshift when reaching the cost tipping point. It was stated however at AWS Summit that Redshift Spectrum can be run without using Amazon Redshift.
3182017 Assuming you have objects on S3 that Athena can consume then you might start with Athena vs. 17112017 Can I Use Both Amazon Athena and Redshift Spectrum. Athena is serverless so there is no infrastructure to manage and you pay only for the queries that you run. Amazon Athena is a serverless query processing engine based on open source Presto. While Redshift services are based on an hourly rate without any penalty even after exceeding the number of queries Athena does not charge for unsuccessful queries. Amazon Athena is similar to Redshift Spectrum though the two services typically address different needs.
One big limitation and differing factor is the ability to use structured data.
The comparison of Amazon Redshift spectrum vs Athena leads to an interesting outcome in terms of pricing. 17112017 Can I Use Both Amazon Athena and Redshift Spectrum. Choosing between Redshift Spectrum and Athena. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Spectrum is a serverless query processing engine that allows to join data that sits in Amazon S3 with data in Amazon Redshift. 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 Athena is focused on extract transform and load ETL data from S3 and has a good integration with AWS Glue.