9 мая 2018 г. · I am kind of evaluating Athena & Redshift Spectrum. Both serve the same purpose, Spectrum needs a Redshift cluster in place whereas Athena is pure serverless.

27 нояб. 2019 г. · On the other hand, Athena uses optimized amount of resource for the query, which may be larger than the Spectrum of a small Redshift cluster ...

11 апр. 2023 г. · When I run queries in Redshift I get insanely longer query times compared to Athena, even for the most simple queries.

12 апр. 2019 г. · For Redshift clusters with ~20 CPUs I've found Athena to perform better for most queries, but larger Redshift clusters may get better performance.

6 июл. 2017 г. · Data stored outside of Redshift will not run anywhere near as fast. The intention of Amazon Redshift Spectrum is to provide access to data ...

29 мар. 2023 г. · I'm currently using DBT and Athena as a data warehouse, and it's able to do transformations and write data back to S3. We don't do any inserts/updates/deletes.

8 мар. 2019 г. · I am currently working on a data pipeline project, my current dilemma is whether to use parquet with Athena or storing it to Redshift.

19 февр. 2020 г. · Are there any scenarios or thresholds where Redshift Spectrum would better support a reporting need, and force a switch from Athena to Redshift?

21 февр. 2022 г. · You would need Redshift if you approach or hit the QuickSight's SPICE limits and would still like your reports to be snappy and load quickly.

25 апр. 2023 г. · AWS Support has confirmed that reading Deep Archive objects with Spectrum and Athena is not supported at this time.