You're reading from Amazon Redshift Cookbook Recipes for building modern data warehousing solutions

Product type Paperback

Published in Jul 2021

Publisher Packt

ISBN-13 9781800569683

Length 384 pages

Edition 1st Edition

Languages

Python

Tools

Amazon Redshift

Concepts

Data Analysis

Authors (3):

Shruti Worlikar

Arumugam

Patel

Preface

1. Chapter 1: Getting Started with Amazon Redshift

2. Chapter 2: Data Management FREE CHAPTER

3. Chapter 3: Loading and Unloading Data

4. Chapter 4: Data Pipelines

5. Chapter 5: Scalable Data Orchestration for Automation

6. Chapter 6: Data Authorization and Security

7. Chapter 7: Performance Optimization

8. Chapter 8: Cost Optimization

9. Chapter 9: Lake House Architecture

10. Chapter 10: Extending Redshift's Capabilities

11. Other Books You May Enjoy

Appendix

Technical requirements

You will need the following technical requirements to complete the recipes in this chapter:

Access to the AWS Console.
An AWS administrator should create an IAM user by following Recipe 1 – Creating an IAM user in the Appendix. This IAM user will be used in some of the recipes in this chapter.
An AWS administrator should create an IAM role by following Recipe 3 – Creating an IAM role for an AWS service in the Appendix. This IAM role will be used in some of the recipes in this chapter.
An AWS administrator should deploy the AWS CloudFormation template (https://github.com/PacktPublishing/Amazon-Redshift-Cookbook/blob/master/Chapter03/chapter_3_CFN.yaml) and create two IAM policies:
a. An IAM policy attached to the IAM user, which will give them access to Amazon Redshift, Amazon RDS, Amazon DynamoDB, Amazon S3, and Amazon EMR.
b. An IAM policy attached to the IAM role, which will allow the Amazon Redshift cluster to access Amazon...