User guide

Table of Contents
What Is Amazon Redshift? .............................................................................................................. 1
Are You a First-Time Amazon Redshift User? ............................................................................. 1
Amazon Redshift Management Overview .................................................................................. 2
Cluster Management ...................................................................................................... 2
Cluster Access and Security ............................................................................................ 2
Monitoring Clusters ........................................................................................................ 3
Databases ................................................................................................................... 4
Clusters ....................................................................................................................................... 5
Overview ............................................................................................................................. 5
About Clusters and Nodes ...................................................................................................... 6
Determining the Number of Nodes ................................................................................... 7
Resizing a Cluster ................................................................................................................. 8
Supported Platforms to Launch Your Cluster ............................................................................... 9
EC2-Classic Platform ..................................................................................................... 9
EC2-VPC Platform ......................................................................................................... 9
Choose a Platform ....................................................................................................... 10
Regions and Availability Zone Considerations ........................................................................... 10
Maintenance Windows .......................................................................................................... 10
Default Disk Space Alarm ..................................................................................................... 11
Renaming Clusters .............................................................................................................. 11
Shutting Down and Deleting Clusters ...................................................................................... 12
Managing Clusters Using the Console .................................................................................... 13
Creating a Cluster ........................................................................................................ 14
Modifying a Cluster ...................................................................................................... 20
Shutting Down or Deleting a Cluster ................................................................................ 22
Rebooting a Cluster ..................................................................................................... 23
Resizing a Cluster ........................................................................................................ 24
Getting Information About Cluster Configuration ................................................................ 26
Getting an Overview of Cluster Status ............................................................................. 26
Taking a Snapshot of a Cluster ....................................................................................... 27
Editing the Default Disk Space Alarm .............................................................................. 28
Working with Cluster Performance Data .......................................................................... 29
Managing Clusters Using the AWS SDK for Java ...................................................................... 29
Manage Clusters Using the Amazon Redshift CLI and API .......................................................... 31
Managing Clusters in an Amazon Virtual Private Cloud (VPC) ..................................................... 32
Overview .................................................................................................................... 32
Creating a Cluster in a VPC ........................................................................................... 33
Managing VPC Security Groups for a Cluster .................................................................... 35
Cluster Subnet Groups ................................................................................................. 36
Security Groups .......................................................................................................................... 43
Overview ............................................................................................................................ 43
Managing Cluster Security Groups Using the Console ................................................................ 44
Creating a Cluster Security Group .................................................................................. 45
Tagging a Cluster Security Group ................................................................................... 46
Managing Ingress Rules for a Cluster Security Group ......................................................... 47
Revoking Ingress Rules for a Cluster Security Group ......................................................... 49
Tagging Ingress Rules for a Cluster Security Group ........................................................... 49
Deleting a Cluster Security Group ................................................................................... 51
Associating a Cluster Security Group with a Cluster ........................................................... 52
Managing Cluster Security Groups Using the AWS SDK for Java ................................................ 52
Manage Cluster Security Groups Using the Amazon Redshift CLI and API ..................................... 55
Parameter Groups ....................................................................................................................... 56
Overview ............................................................................................................................ 56
Configuring the Maximum Size of a Cursor Result Set ................................................................ 57
Configuring Workload Management ........................................................................................ 59
API Version 2012-12-01
iii
Amazon Redshift Management Guide