Why was Amazon Redshift used? Could other services like AWS Glue be used instead?

Amazon Redshift is a columnar, massively parallel processing (MPP) data warehouse designed for large-scale analytics. It excels at complex SQL queries over petabyte‑sized datasets, offers fast query performance through compression, sort keys, and distribution styles, and integrates tightly with S3, Glue, and Athena. Redshift also supports concurrency scaling, automated backups, and fine‑grained access control. While AWS Glue is an ETL service that can move and transform data, it is not a warehouse; it lacks the query optimization and OLAP capabilities of Redshift. Therefore, Redshift is chosen when the primary requirement is analytical querying, reporting, and BI workloads, whereas Glue is used for data ingestion and transformation pipelines that feed into a warehouse like Redshift.