User guide

Configuring the wlm_json_configuration Parameter ............................................................ 69
Managing Parameter Groups Using the Console ....................................................................... 72
Creating a Parameter Group .......................................................................................... 73
Modifying a Parameter Group ........................................................................................ 74
Deleting a Parameter Group .......................................................................................... 76
Associating a Parameter Group with a Cluster .................................................................. 77
Managing Parameter Groups Using the AWS SDK for Java ........................................................ 77
Managing Parameter Groups Using the Amazon Redshift CLI and API .......................................... 80
Snapshots .................................................................................................................................. 82
Overview ............................................................................................................................ 82
Automated Snapshots .................................................................................................. 82
Manual Snapshots ....................................................................................................... 83
Copying Snapshots to Another Region ............................................................................ 83
Restoring a Cluster from a Snapshot ............................................................................... 84
Sharing Snapshots ...................................................................................................... 84
Managing Snapshots Using the Console .................................................................................. 86
Creating a Manual Snapshot .......................................................................................... 87
Deleting a Manual Snapshot .......................................................................................... 88
Copying an Automated Snapshot .................................................................................... 88
Restoring a Cluster from a Snapshot ............................................................................... 89
Sharing a Cluster Snapshot ........................................................................................... 91
Configuring Cross-Region Snapshot Copy ....................................................................... 92
Modifying the Retention Period for Cross-Region Snapshot Copy ......................................... 93
Disabling Cross-Region Snapshot Copy ........................................................................... 94
Managing Snapshots Using the AWS SDK for Java ................................................................... 94
Managing Snapshots Using the Amazon Redshift CLI and API .................................................... 97
Database Encryption .................................................................................................................... 98
Overview ............................................................................................................................ 98
Hardware Security Modules ................................................................................................... 99
Configuring HSM Using the Amazon Redshift Console ....................................................... 99
Configuring HSM Using the Amazon Redshift CLI and API ................................................ 105
Rotating Encryption Keys .................................................................................................... 105
Rotating Encryption Keys Using the Amazon Redshift Console .......................................... 105
Rotating Encryption Keys Using the Amazon Redshift CLI and API ..................................... 106
Purchasing Reserved Nodes ........................................................................................................ 107
Overview .......................................................................................................................... 107
What Are Reserved Node Offerings? ............................................................................. 107
Purchasing a Reserved Node Offering with the Console ........................................................... 108
Listing Reserved Node Offerings .................................................................................. 109
Purchasing Reserved Node Offerings ............................................................................ 109
Purchasing a Reserved Node Offering Using Java ................................................................... 111
Purchasing a Reserved Node Offering Using the Amazon Redshift CLI and API ............................ 114
Controlling Access to Amazon Redshift Resources .......................................................................... 115
Overview of Access to Amazon Redshift Resources ................................................................. 115
Using IAM Users, Groups, and Policies for Cluster Management ........................................ 116
AWS Managed Policies for Amazon Redshift .................................................................. 116
Creating an IAM Group and Users ................................................................................ 116
IAM Policy Elements for Amazon Redshift .............................................................................. 117
IAM Policy Actions for Amazon Redshift ......................................................................... 118
IAM Policy Resources for Amazon Redshift .................................................................... 118
Constructing an Amazon Redshift ARN .................................................................................. 120
Example Policies for Amazon Redshift ................................................................................... 121
Accessing Amazon Redshift Clusters and Databases ....................................................................... 128
Using the Amazon Redshift Management Interfaces ................................................................. 128
Using the AWS SDK for Java ....................................................................................... 129
Signing an HTTP Request ........................................................................................... 131
Setting Up the Amazon Redshift CLI ............................................................................. 134
Connecting to a Cluster ....................................................................................................... 138
API Version 2012-12-01
iv
Amazon Redshift Management Guide