User guide

Configuring Connections in Amazon Redshift .................................................................. 138
Connecting to Clusters From Client Tools and Code ......................................................... 162
Troubleshooting Connection Issues in Amazon Redshift .................................................... 173
Monitoring Cluster Performance .................................................................................................... 179
Overview .......................................................................................................................... 179
Summary of Performance Data ............................................................................................ 180
Amazon Redshift CloudWatch Metrics ........................................................................... 180
Amazon Redshift Query/Load Performance Data ............................................................. 182
Working with Performance Data ............................................................................................ 183
Viewing Cluster Performance Data ................................................................................ 184
Viewing Query Performance Data ................................................................................. 186
Viewing Cluster Metrics During Load Operations ............................................................. 194
Creating an Alarm ...................................................................................................... 195
Working with Performance Metrics in the Amazon CloudWatch Console .............................. 197
Events ..................................................................................................................................... 199
Overview .......................................................................................................................... 199
Viewing Events Using the Console ........................................................................................ 199
Filtering Events .......................................................................................................... 200
Viewing Events Using the AWS SDK for Java ......................................................................... 201
View Events Using the Amazon Redshift CLI and API ............................................................... 202
Event Notifications ............................................................................................................. 202
Overview .................................................................................................................. 202
Amazon Redshift Event Categories and Event Messages .................................................. 204
Managing Event Notifications Using the Amazon Redshift Console ..................................... 209
Managing Event Notifications Using the Amazon Redshift CLI and API ................................ 214
Database Audit Logging .............................................................................................................. 215
Overview .......................................................................................................................... 215
Amazon Redshift Logs ........................................................................................................ 215
Connection Log ......................................................................................................... 216
User Log .................................................................................................................. 216
User Activity Log ........................................................................................................ 217
Enabling Logging ............................................................................................................... 217
Managing Log Files ............................................................................................................ 218
Bucket Permissions for Amazon Redshift Audit Logging .................................................... 218
Bucket Structure for Amazon Redshift Audit Logging ........................................................ 220
Troubleshooting Amazon Redshift Audit Logging ..................................................................... 220
Using AWS CloudTrail for Amazon Redshift ............................................................................ 221
Configuring Auditing Using the Console ................................................................................. 221
Enabling Audit Logging Using the Console ..................................................................... 221
Modifying the Bucket for Audit Logging .......................................................................... 222
Disabling Audit Logging Using the Console ..................................................................... 223
Configuring Logging by Using the Amazon Redshift CLI and API ................................................ 223
Resizing Clusters ....................................................................................................................... 224
Overview .......................................................................................................................... 224
Resize Operation Overview ................................................................................................. 224
Snapshot, Restore, and Resize Operation Overview ................................................................ 225
Tutorial: Using the Resize Operation to Resize a Cluster ........................................................... 226
Prerequisites ............................................................................................................. 227
Step 1: Resize the Cluster ........................................................................................... 227
Step 2: Delete the Sample Cluster ................................................................................ 228
Tutorial: Using the Snapshot, Restore, and Resize Operations to Resize a Cluster ......................... 228
Prerequisites ............................................................................................................. 229
Step 1: Take a Snapshot .............................................................................................. 229
Step 2: Restore the Snapshot into the Target Cluster ........................................................ 230
Step 3: Verify Data in the Target Cluster ......................................................................... 231
Step 4: Resize the Target Cluster .................................................................................. 232
Step 5: Copy Post-Snapshot Data from the Source to the Target Cluster .............................. 233
Step 6: Rename the Source and Target Clusters .............................................................. 234
API Version 2012-12-01
v
Amazon Redshift Management Guide