Home Page Icon
Home Page
Table of Contents for
Amazon Redshift Cookbook
Close
Amazon Redshift Cookbook
by
Amazon Redshift Cookbook
Amazon Redshift Cookbook
Foreword
Contributors
About the authors
About the reviewers
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Conventions used
Get in touch
Share Your Thoughts
Chapter 1: Getting Started with Amazon Redshift
Technical requirements
Creating an Amazon Redshift cluster using the AWS Console
Getting ready
How to do it…
Creating an Amazon Redshift cluster using the AWS CLI
Getting ready
How to do it…
How it works…
Creating an Amazon Redshift cluster using an AWS CloudFormation template
Getting ready
How to do it…
How it works…
Connecting to an Amazon Redshift cluster using the Query Editor
Getting ready
How to do it…
Connecting to an Amazon Redshift cluster using the SQL Workbench/J client
Getting ready
How to do it…
Connecting to an Amazon Redshift Cluster using a Jupyter Notebook
Getting ready
How to do it…
Connecting to an Amazon Redshift cluster using Python
Getting ready
How to do it…
Connecting to an Amazon Redshift cluster programmatically using Java
Getting ready
How to do it…
Connecting to an Amazon Redshift cluster programmatically using .NET
Getting ready
How to do it…
Connecting to an Amazon Redshift cluster using the command line
Getting ready
How to do it…
Chapter 2: Data Management
Technical requirements
Managing a database in an Amazon Redshift cluster
Getting ready
How to do it…
Managing a schema in a database
Getting ready
How to do it…
Managing tables
Getting ready
How to do it…
How it works…
Managing views
Getting ready
How to do it…
Managing materialized views
Getting ready
How to do it…
How it works…
Managing stored procedures
Getting ready
How to do it…
How it works…
Managing UDFs
Getting ready
How to do it…
How it works…
Chapter 3: Loading and Unloading Data
Technical requirements
Loading data from Amazon S3 using COPY
Getting ready
How to do it…
How it works…
Loading data from Amazon EMR
Getting ready
How to do it…
Loading data from Amazon DynamoDB
Getting ready
How to do it…
How it works…
Loading data from remote hosts
Getting ready
How to do it…
Updating and inserting data
Getting ready
How to do it…
Unloading data to Amazon S3
Getting ready
How to do it…
Chapter 4: Data Pipelines
Technical requirements
Ingesting data from transactional sources using AWS DMS
Getting ready
How to do it…
How it works…
Streaming data to Amazon Redshift via Amazon Kinesis Firehose
Getting ready
How to do it…
How it works…
Cataloging and ingesting data using AWS Glue
How to do it…
How it works…
Chapter 5: Scalable Data Orchestration for Automation
Technical requirements
Scheduling queries using the Amazon Redshift query editor
Getting ready
How to do it…
How it works…
Event-driven applications using Amazon EventBridge and the Amazon Redshift Data API
Getting ready
How to do it…
How it works…
Event-driven applications using AWS Lambda
Getting ready
How to do it…
How it works…
Orchestrating using AWS Step Functions
Getting ready
How to do it…
How it works…
Orchestrating using Amazon MWAA
Getting ready
How to do it…
How it works…
Chapter 6: Data Authorization and Security
Technical requirements
Managing infrastructure security
Getting ready
How to do it
Data encryption at rest
Getting ready
How to do it
Data encryption in transit
Getting ready
How to do it
Column-level security
Getting ready
How to do it
How it works
Loading and unloading encrypted data
Getting ready
How to do it
Managing superusers
Getting ready
How to do it
Managing users and groups
Getting ready
How to do it
Managing federated authentication
Getting ready
How to do it
How it works
Using IAM authentication to generate database user credentials
Getting ready
How to do it
Managing audit logs
Getting ready
How to do it
How it works
Monitoring Amazon Redshift
Getting ready
How to do it
How it works
Chapter 7: Performance Optimization
Technical requirements
Amazon Redshift Advisor
Getting ready
How to do it…
How it works…
Managing column compression
Getting ready
How to do it…
How it works…
Managing data distribution
Getting ready
How to do it…
How it works…
Managing sort keys
Getting ready
How to do it…
How it works…
Analyzing and improving queries
Getting ready
How to do it…
How it works…
Configuring workload management (WLM)
Getting ready
How to do it…
How it works…
Utilizing Concurrency Scaling
Getting ready
How to do it…
How it works…
Optimizing Spectrum queries
Getting ready
How to do it…
How it works…
Chapter 8: Cost Optimization
Technical requirements
AWS Trusted Advisor
Getting ready
How to do it…
How it works…
Amazon Redshift Reserved Instance pricing
Getting ready
How to do it…
Configuring pause and resume for an Amazon Redshift cluster
Getting ready
How to do it…
Scheduling pause and resume
Getting ready
How to do it…
How it works…
Configuring Elastic Resize for an Amazon Redshift cluster
Getting ready
How to do it…
Scheduling Elastic Resizing
Getting ready
How to do it…
How it works…
Using cost controls to set actions for Redshift Spectrum
Getting ready
How to do it…
Using cost controls to set actions for Concurrency Scaling
Getting ready
How to do it…
Chapter 9: Lake House Architecture
Technical requirements
Building a data lake catalog using AWS Lake Formation
Getting ready
How to do it…
How it works…
Exporting a data lake from Amazon Redshift
Getting ready
How to do it…
Extending a data warehouse using Amazon Redshift Spectrum
Getting ready
How to do it…
Data sharing across multiple Amazon Redshift clusters
Getting ready
How to do it…
How it works…
Querying operational sources using Federated Query
Getting ready
How to do it…
Chapter 10: Extending Redshift's Capabilities
Technical requirements
Managing Amazon Redshift ML
Getting ready
How to do it…
How it works…
Visualizing data using Amazon QuickSight
Getting ready
How to do it…
How it works…
AppFlow for ingesting SaaS data in Redshift
Getting ready
How to do it…
How it works…
Data wrangling using DataBrew
Getting ready
How to do it…
How it works…
Utilizing ElastiCache for sub-second latency
Getting ready
How to do it…
How it works…
Subscribing to third-party data using AWS Data Exchange
Getting ready
How to do it…
How it works…
Appendix
Recipe 1 – Creating an IAM user
Recipe 2 – Storing database credentials using Amazon Secrets Manager
Recipe 3 – Creating an IAM role for an AWS service
Recipe 4 – Attaching an IAM role to the Amazon Redshift cluster
Why subscribe?
Other Books You May Enjoy
Packt is searching for authors like you
Share Your Thoughts
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Amazon Redshift Cookbook
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset