What it is: The classic Cloud Data Warehouse. It uses MPP (Massively Parallel Processing) to let you run complex SQL queries over petabytes of data.
Data Engineer Note: Unlike BigQuery (which is serverless by default), Redshift traditionally required you to provision "nodes" (clusters), though it now has a "Serverless" option to compete with Google.