Comment by rahulj51

Cost will definitely be a factor but if it's not then I'd suggest Redshift because of the simplicity. Another aspect is how the data will be consumed - Analysts are typically more comfortable using SQL + Redshift. I'd avoid Spark except for very specific use cases as the operational toil is higher with Spark.