Amazon Redshift User Manual

What Is Amazon Redshift? ..................................................................................................................... 1
Clusters ................................................................................................................................................... 4
Managing Clusters Using the Console .................................................................................................. 7
Managing Clusters Using AWS SDK for Java ...................................................................................... 21
Manage Clusters Using Amazon Redshift CLI and API ........................................................................ 23
Managing Clusters in VPC .................................................................................................................... 23
Creating a Cluster in a VPC ........................................................................................................ 24
Cluster Subnet Groups ................................................................................................................ 25
Managing Cluster Subnet Groups Using the Console ...................................................... 26
Managing Cluster Subnet Groups Using AWS SDK for Java ............................................ 29
Manage Cluster Subnet Groups Using Amazon Redshift CLI and API ............................. 31
Security Groups .................................................................................................................................... 32
Managing Security Groups Using the Console .................................................................................... 33
Managing Security Groups Using AWS SDK for Java ......................................................................... 37
Manage Security Group Using Amazon Redshift CLI and API ............................................................. 40
Parameter Groups ................................................................................................................................ 41
Managing Parameter Groups Using the Console ................................................................................. 43
Managing Parameter Groups Using AWS SDK for Java ..................................................................... 47
Manage Parameter Groups Using Amazon Redshift CLI and API ....................................................... 51
Snapshots ............................................................................................................................................. 52
Managing Snapshots Using the Console .............................................................................................. 54
Managing Snapshots Using AWS SDK for Java .................................................................................. 59
Managing Snapshots Using Amazon Redshift CLI and API ................................................................. 62
Events ................................................................................................................................................... 63
Viewing Events Using the Console ....................................................................................................... 63
Viewing Events Using AWS SDK for Java ........................................................................................... 65
View Events Using Amazon Redshift CLI and API ............................................................................... 66
Monitoring Cluster Performance ........................................................................................................... 67
Summary of Performance Data ............................................................................................................ 68
Working with Performance Data ........................................................................................................... 71
Viewing Cluster Performance Data ............................................................................................. 72
Viewing Cluster Metrics During Query Execution ........................................................................ 74
Viewing Cluster Metrics During Load Operations ........................................................................ 77
Creating an Alarm ....................................................................................................................... 78
Working with Performance Metrics in the Amazon CloudWatch Console ................................... 80
Purchasing Reserved Nodes ................................................................................................................ 82
Purchasing a Reserved Node Offering with the Console ..................................................................... 83
Purchasing a Reserved Node Offering Using Java .............................................................................. 86
Purchase a Reserved Node Offering Using Amazon Redshift CLI and API ......................................... 89
Controlling Access to Amazon Redshift Resources ............................................................................. 90
Connecting to a Cluster ........................................................................................................................ 95
Setting Up the SQL Workbench Client .................................................................................................. 96
Connect to Your Cluster by Using the psql Tool .................................................................................. 103
Connect to Your Cluster Using SSL .................................................................................................... 105
Connect to Your Cluster Programmatically ......................................................................................... 107
Connect from Outside of Amazon EC2 - Firewall Timeout Issue ........................................................ 112
Limits .................................................................................................................................................. 114
Using the AWS SDKs ......................................................................................................................... 117
Using the AWS SDK for Java .............................................................................................................. 117
Uploading Client-Side Encrypted Data ............................................................................................... 120
Signing an HTTP Request .................................................................................................................. 124
Document History ............................................................................................................................... 127
API Version 2012-12-01
4
Amazon Redshift Management Guide

Amazon Redshift Specifications

General

Brand	Amazon
Model	Redshift
Category	Software
Language	English