Document history
Note
For a description of new features in Amazon Redshift, see What's new
The following table describes the important documentation changes to the Amazon Redshift Management Guide after June 2018. For notification about updates to this documentation, you can subscribe to an RSS feed.
API version: 2012-12-01
For a list of the changes to the Amazon Redshift Database Developer Guide, see Amazon Redshift Database Developer Guide document history.
| Change | Description | Date |
|---|---|---|
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 186. | October 22, 2024 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 185. | October 9, 2024 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 184. | September 12, 2024 | |
Updates to | September 11, 2024 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 183. | August 8, 2024 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 182. | June 26, 2024 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 181. | May 1, 2024 | |
Update to | March 8, 2024 | |
Updates to | February 21, 2024 | |
Updates to | February 7, 2024 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 180. | December 29, 2023 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 179. | November 9, 2023 | |
Updates to | October 31, 2023 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 178. | September 25, 2023 | |
Updates to | August 16, 2023 | |
Updates to | August 14, 2023 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 177. | August 3, 2023 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 176. | June 8, 2023 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 175. | April 28, 2023 | |
Updates to | April 27, 2023 | |
Updates to | April 7, 2023 | |
Updates to | March 21, 2023 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 174. | March 11, 2023 | |
Updates to | February 2, 2023 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 173. | January 20, 2023 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 172. | November 17, 2022 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 171. | November 9, 2022 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 170. | July 20, 2022 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 169. | June 8, 2022 | |
A new Amazon Redshift patch is being deployed. It takes several weeks for a new version to become available in all Amazon Redshift supported AWS Regions. For more information about this version, see Amazon Redshift patch 168. | April 19, 2022 | |
Support for authentication profiles with Amazon Redshift drivers | You can now connect to Amazon Redshift with an authentication profile. | August 2, 2021 |
Support for cross-VPC endpoints for Amazon Redshift powered by AWS PrivateLink | You can now use Redshift-managed VPC endpoints with Amazon Redshift. | April 1, 2021 |
You can now use the query editor with enhanced VPC routing, longer query run times, and more cluster node types. | February 17, 2021 | |
You can integrate with partners using the Amazon Redshift console. | December 9, 2020 | |
Support for the ability to move clusters between Availability Zones | You can now move RA3 clusters between Availability Zones. | December 9, 2020 |
You can now create ra3.xlplus node types. | December 9, 2020 | |
You can now configure the JDBC driver version 2.0. | November 5, 2020 | |
You can now can write Lambda UDFs to enable external tokenization of data. | October 26, 2020 | |
You can now schedule a query on the Amazon Redshift console. | October 22, 2020 | |
Amazon Redshift can now be accessed using the built-in Data API. Documentation updates include an Amazon Redshift Data API Reference. | September 10, 2020 | |
Updated the guide to describe new query monitoring graphs. | May 7, 2020 | |
Updated the guide to describe usage limits. | April 23, 2020 | |
Updated the guide to describe multi-factor authentication support. | April 20, 2020 | |
Updated elastic resize description. | April 6, 2020 | |
Updated the guide to include ra3.4xlarge node types. | April 2, 2020 | |
Updated the guide to describe the pause and resume cluster operations. | March 11, 2020 | |
Updated the guide to describe the steps to use Microsoft Azure AD as an identity provider. | February 10, 2020 | |
Updated the guide to describe the new RA3 node type. | December 3, 2019 | |
Updated the guide to describe the new Amazon Redshift console. | November 11, 2019 | |
Updates to the security information documentation. | June 24, 2019 | |
Amazon Redshift now supports several enhancements to managing and scheduling snapshots. | April 4, 2019 | |
You can configure workload management (WLM) to enable concurrency scaling mode. For more information, see Configuring workload management. | March 21, 2019 | |
Amazon Redshift now supports new versions of the JDBC and ODBC drivers. For more information, see Configure a JDBC connection. | February 4, 2019 | |
If you need to reschedule your cluster's maintenance window, you have the option to defer maintenance by up to 14 days. If we need to update hardware or make other mandatory updates during your period of deferment, we notify you and make the required changes. Your cluster isn't available during these updates. For more information, see Deferring maintenance. | November 20, 2018 | |
Amazon Redshift provides notification in advance for some events. These events have an
event category of | November 20, 2018 | |
Elastic resize is the fastest method to resize a cluster. Elastic resize adds or removes nodes on an existing cluster, then automatically redistributes the data to the new nodes. Because it doesn't create a new cluster, the elastic resize operation completes quickly, usually in a few minutes. For more information, see Resizing clusters. | November 15, 2018 | |
You can now cancel a resize operation while it is in progress. For more information, see Resize operation overview. | November 2, 2018 | |
You can modify an unencrypted cluster to use AWS Key Management Service (AWS KMS) encryption, using either an AWS-managed key or a customer managed key. When you modify your cluster to enable KMS encryption, Amazon Redshift automatically migrates your data to a new encrypted cluster. You can also migrate an unencrypted cluster to an encrypted cluster by modifying the cluster. | October 16, 2018 | |
You can now use Redshift Spectrum with enhanced VPC routing enabled for your cluster. You might need to perform additional configuration steps. For more information, see Using Amazon Redshift spectrum with enhanced VPC routing. | October 10, 2018 | |
You can now run SQL queries from the Amazon Redshift Management Console. | October 4, 2018 | |
You can now get a detailed view of your workload's performance by looking at the Workload Execution Breakdown chart in the console. For more information, see Analyzing workload performance. | July 30, 2018 | |
You can now determine if your cluster will always be updated to the latest version of Amazon Redshift or to a previous version by choosing a maintenance track. For more information, see Choosing cluster maintenance tracks. | July 26, 2018 |
The following table describes the important changes to the Amazon Redshift Management Guide before July 2018.
| Change | Description | Release date |
|---|---|---|
| New CloudWatch metrics | New CloudWatch metrics added for monitoring query performance. For more information, see Performance data in Amazon Redshift | May 17, 2018 |
|
HSM encryption |
Amazon Redshift supports only AWS CloudHSM for hardware security module (HSM) key management. For more information, see Amazon Redshift database encryption. |
March 6, 2018 |
| IAM Role Chaining | If an IAM role attached to your cluster doesn't have access to the necessary resources, you can chain another role, possibly belonging to another account. Your cluster then temporarily assumes the chained role to access the data. You can also grant cross-account access by chaining roles. Each role in the chain assumes the next role in the chain, until the cluster assumes the role at the end of chain. You can chain a maximum of 10 roles. For more information, see Chaining IAM roles in Amazon Redshift. | February 23, 2018 |
| 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 |
| 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 through a SAML 2.0-compliant identity provider. For more information, see Using IAM authentication to generate database user credentials. | August 11, 2017 |
| Table-level restore supports enhanced VPC routing | Table-level restore is now supported on clusters that use Controlling network traffic with 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 Workload management. | April 21, 2017 |
|
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 Controlling network traffic with Redshift enhanced VPC routing. |
September 15, 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 |
|
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 AWS services on your behalf and Authorizing COPY, UNLOAD, CREATE EXTERNAL FUNCTION, and CREATE EXTERNAL SCHEMA 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 |
|
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 |
|
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 |
|
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 clusters to another AWS Region | Added content about configuring snapshot copy grants to enable copying of AWS KMS-encrypted clusters to another AWS Region. For more information, see Copying AWS KMS–encrypted snapshots to another AWS 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 node type |
Amazon Redshift now 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 Reserved nodes. |
June 9, 2015 |
|
Documentation fixes |
Published various documentation fixes. |
April 30, 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 an Amazon Redshift data warehouse using SQL client tools. |
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 queries and loads. |
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 Use EC2-VPC when you create your cluster and Queries appear to hang and sometimes fail to reach the cluster. |
January 16, 2015 |
|
Documentation update |
Revised the content about the |
January 13, 2015 |
|
Documentation update |
Added missing event notifications and descriptions. For more information, see Amazon Redshift provisioned cluster event notifications. |
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 in Amazon Redshift. |
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 Cluster operations. |
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 Tag 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 |
|
New feature |
Added the ability to terminate queries and loads from the Amazon Redshift console. For more information, see Viewing queries and loads 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 a cluster. |
August 14, 2014 |
|
Documentation update |
Clarified the behavior of the Allow Version Upgrade setting for clusters. For more information, see Amazon Redshift provisioned clusters. |
August 14, 2014 |
|
Documentation update |
Revised procedures, screenshots, and organization of topic about working with clusters in Amazon Redshift console. For more information, see Cluster operations. |
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 Resizing a cluster. |
June 27, 2014 |
|
New feature |
Added the ability to rename clusters. For more information, see Renaming a cluster and Modifying a cluster. |
June 2, 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 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 SSL. |
April 18, 2014 |
|
Documentation update |
Revised and reorganized the topics in the Connecting to an Amazon Redshift data warehouse using SQL client tools 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 Reserved nodes. |
April 2, 2014 |
|
New feature |
Added a section about a new parameter,
|
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 provisioned 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 provisioned clusters 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 provisioned 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 Redshift resources in a VPC and Creating a Redshift provisioned cluster or Amazon Redshift Serverless workgroup 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 with CloudTrail. |
December 13, 2013 |
|
New feature |
Added information about the new user activity log and the
|
December 6, 2013 |
|
New feature |
Updated to describe configuring Amazon Redshift to automatically copy automated and manual snapshots to a secondary AWS Region. For more information about configuring cross-Region snapshot copy, see Copying a snapshot to another AWS 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, Encryption using hardware security modules, and Encryption key rotation. |
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 provisioned cluster event notifications. |
November 11, 2013 |
|
New feature |
Updated to describe IAM resource level permissions. For information about Amazon Redshift IAM permissions, see Security in Amazon Redshift. |
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 a snapshot. |
July 17, 2013 |
|
Documentation fixes |
Published various documentation fixes. |
July 8, 2013 |
|
New console screens |
Updated the Amazon Redshift 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 |
