AWS Redshift Maintenance Announcement (January 9th - March 24th 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.

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 Versions

(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.

In addition to what is included in the major version, this version includes the following new features and improvements:

• 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.

In addition to what is included in the major version, this version includes the following new features and improvements:

• Miscellaneous fixes

---

(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.

In addition to what is included in the major version, this version includes the following new features and improvements:

• Miscellaneous fixes

---

(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.36905. Please contact us at redshift-feedback@amazon.com if you have any questions.

In addition to what is included in the major version, this version includes the following new features and improvements:

• Miscellaneous fixes