Menu
Amazon Redshift
Management Guide (API Version 2012-12-01)

Document History

The following table describes the important changes to the Amazon Redshift Cluster Management Guide.

API version: 2012-12-01

Latest documentation update: October 17, 2017

For a list of the changes to the Amazon Redshift database documentation, go to the Amazon Redshift Database Developer Guide.

For more information about new features, including a list of fixes and the associated cluster version numbers for each release, go to the Amazon Redshift forum.

Change Description Release Date
New DC2 node types The new generation of dense compute (DC) node types offer much better performance at the same price as DC1. To take advantage of performance improvements, you can migrate your DC1 cluster to the newer DC2 node types. For more information, see Clusters and Nodes in Amazon Redshift. October 17, 2017

New JDBC drivers

Amazon Redshift JDBC drivers have been updated to version 1.2.10.1009. Also, JDBC version 4.2 drivers are now supported. For more information, see Configure a JDBC Connection.

October 16, 2017

ACM certificates Amazon Redshift is replacing the SSL certificates on your clusters with AWS Certificate Manager (ACM) issued certificates. ACM is a trusted public certificate authority (CA) that is trusted by most current systems. You might need to update your current trust root CA certificates to continue to connect to your clusters using SSL. For more information, see Transitioning to ACM Certificates for SSL Connections. September 18, 2017
Service-linked roles A service-linked role is a unique type of IAM role that is linked directly to Amazon Redshift. Service-linked roles are predefined by Amazon Redshift and include all the permissions that the service requires to call AWS services on behalf of your Amazon Redshift cluster. For more information, see Using Service-Linked Roles for Amazon Redshift. September 18, 2017
IAM database user authentication You can configure your system to permit users to create user credentials and log on to the database based on their IAM credentials. You can also configure your system to let users sign on using federated single sign-on (SSO) through a SAML 2.0-compliant identity provider. For more information, see Using IAM Authentication to Generate Database User Credentials. August 11, 2017
New JDBC and ODBC drivers

The new JDBC and ODBC drivers support IAM database user authentication. Amazon Redshift JDBC drivers have been updated to version 1.2.7.1003. For more information, see Configure a JDBC Connection.

Amazon Redshift ODBC drivers have been updated to version 1.3.6.1000. For more information, see Configure an ODBC Connection.

August 11, 2017
Table-level restore supports Enhanced VPC Routing Table-level restore is now supported on clusters that use Enhanced VPC Routing. For more information, see Restoring a Table from a Snapshot. July 19, 2017
Query Monitoring Rules Using WLM query monitoring rules, you can define metrics-based performance boundaries for WLM queues and specify what action to take when a query goes beyond those boundaries—log, hop, or abort. You define query monitoring rules as part of your workload management (WLM) configuration. For more information, see Configuring Workload Management. April 21, 2017

New JDBC and ODBC drivers

Amazon Redshift JDBC drivers have been updated to version 1.2.1.1001. Also, JDBC version 4.2 drivers are now supported. For more information, see Configure a JDBC Connection.

Amazon Redshift ODBC drivers have been updated to version 1.3.1.1000. For more information, see Configure an ODBC Connection.

November 18, 2016

Enhanced VPC Routing

When you use Amazon Redshift Enhanced VPC Routing, Amazon Redshift forces all COPY and UNLOAD traffic between your cluster and your data repositories through your Amazon VPC. For more information, see Amazon Redshift Enhanced VPC Routing.

September 15, 2016

New JDBC Drivers

Amazon Redshift JDBC drivers have been updated to version 1.1.17.1017. Also, JDBC version 4.2 drivers are now supported. For more information, see Configure a JDBC Connection.

July 5, 2016

New Connection Log fields The Connection Log audit log has two new fields to track SSL connections. If you routinely load audit logs to an Amazon Redshift table, you will need to add the following new columns to the target table: sslcompression and sslexpansion. May 5, 2016

New ODBC drivers

Amazon Redshift ODBC drivers have been updated to version 1.2.7.1007. For more information, see Configure an ODBC Connection.

March 30, 2016

IAM Roles for COPY and UNLOAD

You can now specify one or more AWS Identity and Access Management (IAM) roles that your cluster can use for authentication to access other AWS services. IAM roles provide a more secure alternative to provide authentication with COPY, UNLOAD, or CREATE LIBRARY commands. For more information, see Authorizing Amazon Redshift to Access Other AWS Services on Your Behalf and Authorizing COPY and UNLOAD Operations Using IAM Roles. March 29, 2016
Restore from Table

You can restore a table from a cluster snapshot to a new table in an active cluster. For more information, see Restoring a Table from a Snapshot.

March 10, 2016

New JDBC Drivers

Amazon Redshift JDBC drivers have been updated to version 1.1.10.1013. For more information, see Configure a JDBC Connection.

You can now set the SSLMode property to specify whether the driver verifies host names when validating TLS/SSL certificates. For more information, see JDBC Driver Configuration Options.

February 18, 2016

Using IAM Condition in policies

You can further restrict access to resources by using the Condition element in IAM policies. For more information, see Using IAM Policy Conditions for Fine-Grained Access Control.

December 10, 2015

Modify Publicly Accessible

You can modify an existing cluster in a VPC to change whether it is publicly accessible. For more information, see Modifying a Cluster.

November 20, 2015

New JDBC Drivers

Amazon Redshift JDBC drivers have been updated to version 1.1.10.1010. For more information, see Configure a JDBC Connection.

Amazon RedshiftODBC drivers have been updated to version 1.2.6.1006. For more information, see Configure an ODBC Connection.

November 19, 2015

Documentation Fixes

Published various documentation fixes.

August 28, 2015

Documentation Update

Updated troubleshooting guidance about configuring network settings to ensure that hosts with different maximum transmission unit (MTU) sizes can determine the packet size for a connection. For more information, see Queries Appear to Hang and Sometimes Fail to Reach the Cluster.

August 25, 2015

Documentation Update

Revised entire section about parameter groups for better organization and clarity. For more information, see Amazon Redshift Parameter Groups.

August 17, 2015

New JDBC Drivers

Amazon Redshift JDBC drivers have been updated to version 1.1.7. For more information, see Configure a JDBC Connection.

August 14, 2015

WLM Dynamic Properties

The WLM configuration parameter now supports applying some properties dynamically. Other properties remain static changes and require that associated clusters be rebooted so that the configuration changes can be applied. For more information, see WLM Dynamic and Static Properties and Amazon Redshift Parameter Groups.

August 3, 2015

Copy KMS Encrypted Custers to Another Region Added content about configuring snapshot copy grants to enable copying of AWS KMS-encrypted clusters to another region. For more information, see Copying AWS KMS-Encrypted Snapshots to Another Region.

July 28, 2015

Documentation Update

Updated the database encryption section to better explain how Amazon Redshift uses AWS KMS or HSMs for managing keys, and how the encryption process works with each of these options. For more information, see Amazon Redshift Database Encryption.

July 28, 2015

New JDBC Drivers

Amazon Redshift JDBC drivers have been updated to version 1.1.7. For more information, see Configure a JDBC Connection.

July 2, 2015

New Node Type

Amazon Redshiftnow offers a new node type, DS2. Updated documentation references to existing node types to use new names introduced in this release. Also revised the section to better explain the node type combinations and clarify default quota limits. For more information, see Clusters and Nodes in Amazon Redshift.

June 9, 2015

Reserved Node Offerings Added content about new reserved node offerings. Also revised the section to better explain and compare the available offerings, and provided examples to demonstrate how on-demand and reserved node pricing affect billing. For more information, see Overview.

June 9, 2015

New ODBC Drivers

Amazon Redshift ODBC driver have been updated. Added a section for previous versions of these drivers and a link to release notes for the drivers. For more information, see Configure an ODBC Connection.

June 5, 2015

Documentation Fixes

Published various documentation fixes.

April 30, 2015

Documentation Update

Updated the download links to new versions of the Amazon Redshift JDBC drivers, and added a section for previous versions of these drivers. Also added a link to release notes for the drivers. For more information, see Configure a JDBC Connection.

April 1, 2015

Documentation Update

Added downloads for new versions of the Amazon Redshift JDBC drivers. Also updated the format of the Amazon Redshift JDBC URL. For more information, see Configure a JDBC Connection.

Added cluster security group ingress rules as a taggable resource. For more information, see Tagging Resources in Amazon Redshift.

Updated the instructions for adding a cluster security group ingress rule, and added instructions for tagging a cluster security group ingress rule. For more information, see Managing Cluster Security Groups Using the Console.

March 16, 2015

New Feature

This release of Amazon Redshift introduces new ODBC and JDBC drivers optimized for use with Amazon Redshift. For more information, see Connecting to a Cluster.

February 26, 2015

New Feature

This release of Amazon Redshift introduces cluster performance metrics that allow you to view and analyze query execution details. For more information, see Viewing Query Performance Data.

February 26, 2015

Documentation Update

Added a new example policy that demonstrates granting permission to common AWS service actions and resources on which Amazon Redshift relies. For more information, see Customer Managed Policy Examples.

January 16, 2015

Documentation Update

Updated guidance about setting the maximum transmission unit (MTU) to disable TCP/IP jumbo frames. For more information, see Supported Platforms to Launch Your Cluster and Queries Appear to Hang and Sometimes Fail to Reach the Cluster.

January 16, 2015

Documentation Update

Revised the content about the wlm_json_configuration parameter, and provided example syntax to configure this parameter by using the AWS CLI on the Linux, Mac OS X, and Microsoft Windows operating systems. For more information, see Configuring Workload Management.

January 13, 2015

Documentation Update

Added missing event notifications and descriptions. For more information, see Amazon Redshift Event Categories and Event Messages.

January 8, 2015

Documentation Update

Updated guidance about IAM policies for Amazon Redshift actions and resources. Revised the section to improve organization and clarity. For more information, see Security.

November 21, 2014

New Feature

This release of Amazon Redshift introduces the ability to encrypt clusters using encryption keys from AWS Key Management Service (AWS KMS). AWS KMS combines secure, highly available hardware and software to provide a key management system scaled for the cloud. For more information about AWS KMS and encryption options for Amazon Redshift, see Amazon Redshift Database Encryption and Managing Clusters Using the Console.

November 12, 2014

New Feature

This release of Amazon Redshift introduces the ability to tag resources, such as clusters and snapshots. Tags enable you to provide user-defined metadata to categorize your billing reports based on cost allocation, and to help you better identify resources at a glance. For more information, see Tagging Resources in Amazon Redshift.

November 4, 2014

New Feature

Increased the maximum node limit to 128 nodes for dw1.8xlarge and dw2.8xlarge node sizes. For more information, see Clusters and Nodes in Amazon Redshift.

October 30, 2014

Documentation Update

Added links to the Microsoft Visual C++ 2010 Redistributable Packages that are required for Amazon Redshift to use PostgreSQL ODBC drivers. For more information, see Install and Configure the Amazon Redshift ODBC Driver on Microsoft Windows Operating Systems.

October 30, 2014

New Feature

Added the ability to terminate queries and loads from the Amazon Redshift console. For more information, see Viewing Query Performance Data and Viewing Cluster Metrics During Load Operations.

October 28, 2014

Documentation Fixes

Published various documentation fixes.

October 17, 2014

New Content

Added content about shutting down clusters and deleting clusters. For more information, see Shutting Down and Deleting Clusters and Deleting a Cluster.

August 14, 2014

Documentation Update

Clarified the behavior of the Allow Version Upgrade setting for clusters. For more information, see Overview.

August 14, 2014

Documentation Update

Revised procedures, screenshots, and organization of topic about working with clusters in Amazon Redshift console. For more information, see Managing Clusters Using the Console.

July 11, 2014

New Content

Added a new tutorial about resizing Amazon Redshift clusters, including how to resize a cluster while minimizing the amount of time that the cluster is in read-only mode. For more information, see Tutorial: Resizing Clusters in Amazon Redshift.

June 27, 2014

New Feature

Added the ability to rename clusters. For more information, see Renaming Clusters and Modifying a Cluster.

June 2, 2014

Documentation Update

Updated the .NET code example to use the ODBC data provider when connecting to a cluster programmatically by using .NET. For more information, see Connecting to a Cluster by Using .NET.

May 15, 2014

New Feature

Added options to select a different parameter group and security group when you restore a cluster from a snapshot. For more information, see Restoring a Cluster from a Snapshot.

May 12, 2014

New Feature

Added new section to describe how to configure a default Amazon CloudWatch alarm to monitor the percentage of disk space used in an Amazon Redshift cluster. This alarm is a new option in the cluster creation process. For more information, see Default Disk Space Alarm.

April 28, 2014

Documentation Update

Clarified information about Elliptic curve Diffie—Hellman Exchange (ECDHE) support in Amazon Redshift. For more information, see Connect Using SSL.

April 22, 2014

New Feature

Added statement about Amazon Redshift support for the Elliptic curve Diffie—Hellman (ECDH) key agreement protocol. For more information, see Connect Using SSL.

April 18, 2014

Documentation Update

Revised and reorganized the topics in the Connecting to a Cluster section. Added more information about JDBC and ODBC connections, and a new troubleshooting section for connection issues. April 15, 2014

Documentation Update

Added version in IAM policy examples throughout the guide.

April 3, 2014

Documentation Update

Added information about how pricing works when you resize a cluster. For more information, see Purchasing Amazon Redshift Reserved Nodes.

April 2, 2014

New Feature

Added a section about a new parameter, max_cursor_result_set_size, which sets the maximum result set size, in megabytes, that can be stored per individual cursor. This parameter value also affects the number of concurrently active cursors for the cluster. For more information, see Amazon Redshift Parameter Groups.

March 28, 2014

New Feature

Added explanation about the Cluster Version field now including both cluster engine version and database revision number. For more information, see Amazon Redshift Clusters.

March 21, 2014

New Feature

Updated the resize procedure to show the new resize progress information on the cluster's Status tab. For more information, see Resizing a Cluster.

March 21, 2014

Documentation Update

Reorganized and updated What Is Amazon Redshift? and revised Amazon Redshift Management Overview. Published various documentation fixes. February 21, 2014

New Feature

Added new node types and sizes for Amazon Redshift clusters, and rewrote the related cluster overview topic for better organization and clarity based on feedback. For more information, see Amazon Redshift Clusters.

January 23, 2014

New Feature

Added information about using elastic IP (EIP) addresses for publicly-accessible Amazon Redshift clusters in virtual private clouds. For more information about EIP in Amazon Redshift, see Managing Clusters in an Amazon Virtual Private Cloud (VPC) and Creating a Cluster in a VPC.

December 20, 2013

New Feature

Added information about the AWS CloudTrail logs for Amazon Redshift. For more information about Amazon Redshift support for CloudTrail, see Logging Amazon Redshift API Calls with AWS CloudTrail.

December 13, 2013

New Feature

Added information about the new user activity log and the enable_user_activity_logging database parameter for the database audit logging feature in Amazon Redshift. For more information about database audit logging, see Database Audit Logging. For more information about database parameters, see Amazon Redshift Parameter Groups.

December 6, 2013

New Feature

Updated to describe configuring Amazon Redshift to automatically copy automated and manual snapshots to a secondary region. For more information about configuring cross-region snapshot copy, see Copying Snapshots to Another Region.

November 14, 2013

New Feature

Added section to describe Amazon Redshift audit logging for connection and user activity, and storing these logs in Amazon S3. For more information about database audit logging, see Database Audit Logging.

November 11, 2013

New Feature

Added section to describe Amazon Redshift encryption with new features for managing encryption keys in a hardware security module (HSM) and rotating encryption keys. For more information about encryption, HSM, and key rotation, see Amazon Redshift Database Encryption, About Encryption for Amazon Redshift Using Hardware Security Modules, and About Rotating Encryption Keys in Amazon Redshift.

November 11, 2013

New Feature

Updated to describe publishing notifications of Amazon Redshift events by using Amazon SNS. For information about Amazon Redshift event notifications, see Amazon Redshift Event Notifications.

November 11, 2013

New Feature

Updated to describe IAM resource level permissions. For information about Amazon Redshift IAM permissions, see Security.

August 9, 2013

New Feature

Updated to describe restore progress metrics. For more information, see Restoring a Cluster from a Snapshot.

August 9, 2013

New Feature

Updated to describe cluster snapshot sharing and create snapshot progress metrics. For more information, see Sharing Snapshots.

July 17, 2013

Documentation Fixes

Published various documentation fixes.

July 8, 2013

New Console Screens

Updated the Amazon Redshift Cluster Management Guide to match changes in the Amazon Redshift console.

April 22, 2013

New Guide

This is the first release of the Amazon Redshift Management Guide.

February 14, 2013