Amazon Redshift: The Definitive Guide

Amazon Redshift powers analytic cloud data warehouses worldwide, from startups to some of the largest enterprise data warehouses available today. This practical guide thoroughly examines this managed service and demonstrates how you can use it to extract value from your data immediately, rather than go through the heavy lifting required to run a typical data warehouse.

Analytic specialists Rajesh Francis, Rajiv Gupta, and Milind Oke detail Amazon Redshift's underlying mechanisms and options to help you explore out-of-the box automation. Whether you're a data engineer who wants to learn the art of the possible or a DBA looking to take advantage of machine learning-based auto-tuning, this book helps you get the most value from Amazon Redshift.

By understanding Amazon Redshift features, you'll achieve excellent analytic performance at the best price, with the least effort. This book helps you:

• Build a cloud data strategy around Amazon Redshift as foundational data warehouse
• Get started with Amazon Redshift with simple-to-use data models and design best practices
• Understand how and when to use Redshift Serverless and Redshift provisioned clusters
• Take advantage of auto-tuning options inherent in Amazon Redshift and understand manual tuning options
• Transform your data platform for predictive analytics using Redshift ML and break silos using data sharing
• Learn best practices for security, monitoring, resilience, and disaster recovery
• Leverage Amazon Redshift integration with other AWS services to unlock additional value

Rajesh Francis is an Analytics Customer Experience Specialist at AWS and is responsible for driving the AWS market and technical strategy for data warehousing and analytics. Rajesh works closely with large strategic customers to help them adopt Analytics services and new features, develop long-term partnerships, and feed customer requirements back to service teams to guide the direction of our product offerings. In his previous roles, Rajesh has experience as a Solutions Architect and a consultant for over 20 years working in a wide range of domains, helping customers gain business insights with AWS Analytics solutions and SAP Analytics.

Rajiv Gupta is an Analytics Specialist who has been working in the Data Warehousing space for 20 years. He has worked with hundreds of companies to help them architect / build / optimize and modernize their data platforms. Most recently, Rajiv has been working as manager of Solution Architects, partnered closely with the Amazon Redshift Service team. Rajiv’s team helps customers migrate their analytics platforms using the latest techniques to ensure scalability, reliability, and efficiency while being secure, easy to operate and cost optimized. Rajiv’s team also captures valuable feedback from customers to know exactly how big & small organizations are using data to help inform and drive the future of the AWS analytics stack.

Milind Oke is an Analytics Specialist Solutions Architect with over two decades of experience architecting and building enterprise grade Data Warehousing solutions and platforms. He holds AWS certifications for AWS Certified Solutions Architect Associate, AWS Certified Data Analytics Speciality, AWS Certified Security Speciality, and is based out of New York. He has worked directly with numerous companies in the financial services sector to design the architecture, deliver the build and modernize their data platforms. At Amazon Web Services, he has engaged with hundreds of customers to develop cloud native analytical capabilities or migrate their existing workloads to leverage the scalability, reliability, and agility of the cloud while being secure and cost efficient. While working with customers directly he also liaises closely with the Database Engineering and Product Management teams to help drive the direction of Amazon Redshift.