[Announcement] Amazon Redshift Maintenance (January 19th 2022 - March 25th 2022)

Major Version (01/19/2022)

We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region and maintenance window settings. You can view or change your maintenance window settings from the AWS Management Console. After your cluster has been patched, the new cluster version will be Build 1.0.34934. Please contact us at redshift-feedback@amazon.com if you have any questions.

This version includes the following new features and improvements:

• Amazon Redshift: The database users that are automatically created when using GetClusterCredentials API to get temporary credentials will now be created with "IAM:" prefix in the database.
• Amazon Redshift: User names from this version are treated as case sensitive when surrounded by double quotes irrespective of the value of the configuration parameter "enable_case_sensitive_identifier".
• Amazon Redshift: Customers can use ST_Intersection to calculate the intersection of two geometries.
• Amazon Redshift: Automatically discovering spatial reference system id (SRID) during COPY of shapefiles when .prj file next to .shp file exists.
• Amazon Redshift: Customers can combine two sketches that appear in separate columns into one.
• Amazon Redshift: Added support for AUTO table property for distribution style in CTAS.
• Amazon Redshift: Customers can use St_GeoHash function to return the geohash value of an input point.
• Amazon Redshift: Amazon Redshift ML now supports unsupervised training with K-Means clustering.
• Amazon Redshift: Added support for converting interleaved sort keys to compound sort keys or no sort key with Alter Sortkey command.
• Amazon Redshift: Added support for the COPY command to automatically split large CSV format files into smaller ranges and scan in parallel.
• Amazon Redshift: Added new Redshift Advisor recommendation to switch to specialized column data types (SUPER, GEOMETRY) in beneficial use cases.

Additionally, the following fixes are included:

• With the performance improvement for the numeric datatype, this resolves a sig11 issue with all customers using drivers that send numeric to Redshift server in binary mode like .Net driver.

---

Minor Version(s)
(02/07/2022)

We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region and maintenance window settings. You can view or change your maintenance window settings from the AWS Management Console. After your cluster has been patched, the new cluster version will be Build 1.0.35480. Please contact us at redshift-feedback@amazon.com if you have any questions.

This version includes the following new features and improvements in addition to what is available in the major version:

• Amazon Redshift: Public Preview of Redshift Streaming Ingestion for Kinesis Data Streams (KDS) pulls data from a KDS stream into a Redshift Materialized View (MV) in near real-time with high throughput. Please note: Preview features are not to be used to run production workloads. To get started see the Redshift documentation.

Additionally, the following fixes are included:

• Fixed a rare situation where with Materialized View auto refresh enabled, external functions cause Redshift cluster instability.

---

(02/15/2022)

We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region and maintenance window settings. You can view or change your maintenance window settings from the AWS Management Console. After your cluster has been patched, the new cluster version will be Build 1.0.35649. Please contact us at redshift-feedback@amazon.com if you have any questions.

This version includes the following new features and improvements in addition to what is available in the major version:

• Amazon Redshift: Public Preview of Redshift Streaming Ingestion for Kinesis Data Streams (KDS) pulls data from a KDS stream into a Redshift Materialized View (MV) in near real-time with high throughput. Please note: Preview features are not to be used to run production workloads. To get started see the Redshift documentation.

Additionally, the following fixes are included:

• Fixed a rare situation where with Materialized View auto refresh enabled, external functions cause Redshift cluster instability.

---

(03/03/2022)

We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region and maintenance window settings. You can view or change your maintenance window settings from the AWS Management Console. After your cluster has been patched, the new cluster version will be Build 1.0.36224. Please contact us at redshift-feedback@amazon.com if you have any questions.

This version includes the following fixes in addition to what is available in the major version:

• Fixes an issue that causes some data sharing queries being stuck when running on Concurrency Scaling clusters.
• Fixed a rare situation where with Materialized View auto refresh enabled, external functions cause Redshift cluster instability.

---

(03/25/2022)

We will be patching your Amazon Redshift clusters during your system maintenance window in the coming weeks. The timing of the patch will depend on your region and maintenance window settings. You can view or change your maintenance window settings from the AWS Management Console. After your cluster has been patched, the new cluster version will be Build 1.0.36905. Please contact us at redshift-feedback@amazon.com if you have any questions.

This version includes the following fixes in addition to what is available in the major version:

• Miscellaneous fixes