Book : Amazon Redshift Cookbook Recipes For Building Modern.

-Titulo Original : Amazon Redshift Cookbook Recipes For Building Modern Data Warehousing Solutions

-Fabricante :

Packt Publishing

-Descripcion Original:

Discover how to build a cloud-based data warehouse at petabyte-scale that is burstable and built to scale for end-to-end analytical solutions Key Features Discover how to translate familiar data warehousing concepts into Redshift implementation Use impressive Redshift features to optimize development, productionizing, and operations processes Find out how to use advanced features such as concurrency scaling, Redshift Spectrum, and federated queries Book Description Amazon Redshift is a fully managed, petabyte-scale AWS cloud data warehousing service. It enables you to build new data warehouse workloads on AWS and migrate on-premises traditional data warehousing platforms to Redshift. This book on Amazon Redshift starts by focusing on Redshift architecture, showing you how to perform database administration tasks on Redshift. Youll then learn how to optimize your data warehouse to quickly execute complex analytic queries against very large datasets. Because of the massive amount of data involved in data warehousing, designing your database for analytical processing lets you take full advantage of Redshifts columnar architecture and managed services. As you advance, youll discover how to deploy fully automated and highly scalable extract, transform, and load (ETL) processes, which help minimize the operational efforts that you have to invest in managing regular ETL pipelines and ensure the timely and accurate refreshing of your data warehouse. Finally, youll gain a clear understanding of Redshift use cases, data ingestion, data management, security, and scaling so that you can build a scalable data warehouse platform. By the end of this Redshift book, youll be able to implement a Redshift-based data analytics solution and have understood the best practice solutions to commonly faced problems. What you will learn Use Amazon Redshift to build petabyte-scale data warehouses that are agile at scale Integrate your data warehousing solution with a data lake using purpose-built features and services on AWS Build end-to-end analytical solutions from data sourcing to consumption with the help of useful recipes Leverage Redshifts comprehensive security capabilities to meet the most demanding business requirements Focus on architectural insights and rationale when using analytical recipes Discover best practices for working with big data to operate a fully managed solution Who this book is for This book is for anyone involved in architecting, implementing, and optimizing an Amazon Redshift data warehouse, such as data warehouse developers, data analysts, database administrators, data engineers, and data scientists. Basic knowledge of data warehousing, database systems, and cloud concepts and familiarity with Redshift will be beneficial. Table of Contents Getting Started with Amazon Redshift Data Management Loading & Unloading data Data Pipelines Scalable Data Orchestration for Automation Data Authorization & Security Performance Optimization Cost Optimization Lake House Architecture Extending Redshift Capabilities Review Im super excited to see Amazon Redshift Cookbook. It is a great introduction to Redshift, with step-by-step instructions from something as simple as setting up your cluster and loading data to more complex like setting up federation with Amazon Aurora or streaming data to Redshift from Amazon Kinesis Firehose. It is also good hands on manual to help you become a Redshift professional, covering topics like performance and cost optimization, data orchestration and security. Highly recommend! -- Yan Leshinsky, Vice President, Redshift at Amazon Web Services (AWS) About the Author Shruti Worlikar is a cloud professional with technical expertise in data lakes and analytics across cloud platforms. Her background has led her to become an expert in on-premises-to-cloud migrations and building cloud-based scalable analytics applications. Shruti earned her bachelors d