Lucy I want to understand what Amazon Redshift is in data engineering. How does it work as a cloud-based data warehouse for big data analytics? Can someone also explain its key features and real-world applications?