You need to perform ad-hoc business analytics queries on well-structured data. Data comes in constantly at a high
velocity. Your business intelligence team can understand SQL. What AWS service(s) should you look to first?
Kinesis Firehose + RDS
Kinesis Firehose + RedShift
EMR using Hive
EMR running Apache Spark
Kinesis Firehose provides a managed service for aggregating streaming data and inserting it into RedShift. RedShift also
supports ad-hoc queries over well-structured data using a SQL-compliant wire protocol, so the business team should be
able to adopt this system easily.