Book Image

Hands-On Amazon Redshift for Data Warehousing [Video]

By : James Cross
Book Image

Hands-On Amazon Redshift for Data Warehousing [Video]

By: James Cross

Overview of this book

Amazon Redshift is a low-cost cloud data platform that can scale from gigabytes to petabytes on a high-performance, column-oriented SQL engine. Amazon Redshift brings the power of scale-out architecture to the world of traditional data warehousing. In this course, you will explore this low-cost, cloud-based storage, which can be scaled up or down to meet your true size and performance needs. You will learn to configure a sample data warehouse. Next, you will explore Redshift's internal workings and architecture, and learn what makes it so fast. You will get hands-on experience connecting, querying, and building BI and data viz products and learn how to secure, maintain, and administer your new platform. By the end of this course, you will be able to scale from gigabytes to petabytes on this high-performance, column-oriented SQL engine. All the code files related to this course are available on Github at - https://github.com/PacktPublishing/Hands-On-Amazon-Redshift-for-Data-Warehousing-V-
Table of Contents (6 chapters)
Chapter 4
Optimizing Redshift for Scale
Content Locked
Section 1
Ingesting Enormous Volumes of Data by Copying Directly from S3
Learn how to use manifest files to copy vast amounts of data efficiently into Redshift. - Learn how does Redshift run a copy command - Understand manifest files - Leverage manifests to copy data