Cluster versions for Amazon Redshift - Amazon Redshift

Cluster versions for Amazon Redshift

Amazon Redshift regularly releases cluster versions. Your Amazon Redshift clusters are patched during your system maintenance window. The timing of the patch depends on your AWS Region and maintenance window settings. You can view or change your maintenance window settings from the Amazon Redshift console. For more information about maintenance, see Cluster maintenance.

You can view the cluster version of your cluster on the Amazon Redshift console on the Maintenance tab of the cluster details. Or you can see the cluster version in the output of the SQL command:

SELECT version();

Amazon Redshift patch 182

Cluster versions in this patch:

  • 1.0.70953 – Amazon Redshift Serverless version – Released on July 11, 2024

  • 1.0.70890 – Current track version – Released on July 11, 2024

  • 1.0.70716 – Amazon Redshift Serverless version – Released on July 8, 2024

  • 1.0.70695 – Current track version – Released on July 8, 2024

  • 1.0.69945 – Amazon Redshift Serverless version – Released on June 27, 2024

  • 1.0.69938 – Current track version – Released on June 27, 2024

New features and improvements in this patch

  • Updates LISTAGG, MEDIAN, PERCENTILE_CONT and PERCENTILE_DISC to no longer require user-defined tables. Queries that reference catalog tables or that don't reference any tables can also use these functions.

  • Reduces query-planning time for datasharing read queries by consolidating temp tables across multiple queries within a single session, for high-concurrency workloads.

  • Provides general availability of Redshift machine learning (ML) integration with Amazon SageMaker Jumpstart, for bringing your own large-language models.

  • Introduces support for the SUPER input and output data type in Redshift ML.

  • Enables support for an UPDATE statement with a JOIN clause when the target table is protected by a dynamic data-masking policy and referenced in the JOIN clause.

  • Allows querying of a zero-ETL database on Redshift, even after the integration is deleted from source.

  • Fixes a replication error that could cause zero-ETL integration to fail. This makes an integration more resilient.

  • Allows users other than the user who created a zero-ETL integration to query the data, after GRANT permissions.

  • Fixes an out-of-memory issue that could cause cluster restarts in an Amazon Redshift provisioned cluster with zero-ETL integration enabled.

  • Updates RDS for MySQL zero-ETL integration with Redshift to support varbinary/binary datatypes.

  • Updates RDS for MySQL zero-ETL integration with Redshift to support MEDIUMTEXT and LONGTEXT data types.

  • Enables custom SORT keys on zero-ETL tables.

  • Enables creation of an RDS for MySQL zero-ETL integration with Redshift, from a source RDS Multi-AZ DB cluster. A Multi-AZ DB cluster is a semisynchronous, high-availability deployment mode of Amazon RDS with two readable replica DB instances.

  • Enables a user to connect to an Amazon MSK cluster from an Amazon Redshift streaming consumer client by specifying the Amazon MSK cluster's broker URI in the external schema definition needed to associate an Amazon Redshift streaming materialized view with an Amazon MSK topic. This feature removes the need to obtain the Amazon MSK bootstrap broker node name by calling the GetBootStrapBroker API on the Amazon MSK cluster over an internet gateway.

  • Resolves the issue with resuming Amazon Redshift Serverless instances, enabling an existing database user to resume a Serverless instance when connecting to databases in Amazon Redshift query editor v2, using the IAM Identity Center authentication method.

  • Optimizes CDC replication and reduced resource utilization on Redshift compute by moving to table-based sharding.

  • Improves query performance using enhanced resource prediction in workload management (WLM).

  • Fixes queries failing on concurrency scaling clusters with the message: ran out of WLM queues for restart.

  • Fixes a workload management (WLM) issue where Amazon Redshift falls back to manual WLM when customers try to apply an invalid WLM configuration.

  • Allows data sharing consumers to run read queries even when the producer is down due to planned maintenance or an unplanned outage.

Amazon Redshift patch 181

Cluster versions in this patch:

  • 1.0.70665 – Amazon Redshift Serverless version – Released on July 8, 2024

  • 1.0.70634 – Current track version – Released on July 8, 2024

  • 1.0.69954 – Amazon Redshift Serverless version – Released on June 26, 2024

  • 1.0.69952 – Current track version – Released on June 26, 2024

  • 1.0.69497 – Amazon Redshift Serverless version – Released on June 18, 2024

  • 1.0.69451 – Current track version – Released on June 18, 2024

  • 1.0.69076 – Amazon Redshift Serverless version – Released on June 14, 2024

  • 1.0.69065 – Current track version – Released on June 14, 2024

  • 1.0.68555 – Amazon Redshift Serverless version – Released on May 31, 2024

  • 1.0.68540 – Current track version – Released on May 31, 2024

  • 1.0.68328 – Amazon Redshift Serverless version – Released on May 23, 2024

  • 1.0.68205 – Current track version – Released on May 23, 2024

  • 1.0.67796 – Amazon Redshift Serverless version – Released on May 15, 2024

  • 1.0.67788 – Current track version – Released on May 15, 2024

  • 1.0.67308 – Amazon Redshift Serverless version – Released on May 1, 2024

  • 1.0.67305 – Current track version – Released on May 1, 2024

New features and improvements in this patch

  • Introduces support to alter the distribution key and sort key of materialized views.

  • Introduces support for the 'lower_attribute_names()' and 'upper_attribute_names()' functions which modify the case of attribute names for SUPER object values.

  • Fixes an issue in CREATE TABLE LIKE when using an identity column. Previously, the new table would inherit the identifier from the source table. This caused problems if the source table was later dropped, since the identifier would become invalid in the new table.

  • Fixes an issue preventing some external tables from showing in SVV_ALL_TABLES.

  • Improves cluster bootstrap time, and speeds up query initialization for high concurrent workloads.

  • Fixes an issue with federated query that caused errors when passing split_part() functions to the federated source to RDS and Aurora MySQL

  • Supports user initiated changes to the distribution key through ALTER TABLE...ALTER DISTSTYLE KEY DISTKEY commands on provisioned concurrency scaling clusters and serverless autoscaling compute.

  • Supports manually refreshed materialized views that involve aggregation on provisioned concurrency scaling and serverless autoscaling compute.

  • Adds support for zero-ETL to handle records up to 16 MB in size and for supporting SUPER values up to 16 MB.

  • Enhances error messages during initial sync in zero-ETL from Aurora MySQL by providing additional details like schema and table name.

  • Introduces support for tagging with Amazon Redshift ML CREATE MODEL. With this improvement, you can now tag Amazon SageMaker resources used by Amazon Redshift ML. Tagging helps you manage, identify, organize, search for, and filter resources.

  • Improves the performance of queries involving Lambda user-defined functions (UDFs) by optimizing the data processing with the AWS Lambda.

  • Reduces memory utilization during data ingestion in sorted tables of elastically resized and serverless clusters.

  • Adds support for newlines (\n) in column query_text in view SYS_QUERY_HISTORY and for column text in view SYS_QUERY_TEXT.

Amazon Redshift patch 180

Cluster versions in this patch:

  • 1.0.68520 – Trailing track version – Released on May 28, 2024

  • 1.0.67699 – Trailing track version – Released on May 15, 2024

  • 1.0.66960 – Trailing track version – Released on April 21, 2024

  • 1.0.66954 – Current track version – Released on April 21, 2024

  • 1.0.66276 – Current track version – Released on April 12, 2024

  • 1.0.66290 – Amazon Redshift Serverless version – Released on April 10, 2024

  • 1.0.63590 – Current track version – Released on February 19, 2024

  • 1.0.63567 – Amazon Redshift Serverless version – Released on February 16, 2024

  • 1.0.63282 – Amazon Redshift Serverless version – Released on February 13, 2024

  • 1.0.63269 – Current track version – Released on February 13, 2024

  • 1.0.63215 – Amazon Redshift Serverless version – Released on February 12, 2024

  • 1.0.63205 – Current track version – Released on February 12, 2024

  • 1.0.63030 – Amazon Redshift Serverless version – Released on February 7, 2024

  • 1.0.62913 – Current track version – Released on February 7, 2024

  • 1.0.62922 – Amazon Redshift Serverless version – Released on February 5, 2024

  • 1.0.62878 – Current track version – Released on February 5, 2024

  • 1.0.62698 – Amazon Redshift Serverless version – Released on January 31, 2024

  • 1.0.62614 – Current track version – Released on January 31, 2024

  • 1.0.61687 – Amazon Redshift Serverless version – Released on January 5, 2024

  • 1.0.61678 – Current track version – Released on January 5, 2024

  • 1.0.61567 – Amazon Redshift Serverless version – Released on December 31, 2023

  • 1.0.61559 – Current track version – Released on December 31, 2023

  • 1.0.61430 – Amazon Redshift Serverless version – Released on December 29, 2023

  • 1.0.61395 – Current track version – Released on December 29, 2023

New features and improvements in this patch

  • Changes CURRENT_USER to no longer truncate the returned username to 64 characters.

  • Adds the ability to apply data masking policies on standard views and late binding views.

  • Adds the ability to apply dynamic data masking (DDM) to scalar attributes in SUPER data type columns.

  • Adds OBJECT_TRANSFORM SQL function. For more information, see OBJECT_TRANSFORM function in the Amazon Redshift Database Developer Guide.

  • Adds the ability to apply AWS Lake Formation fine-grained access control to your nested data, and query with Amazon Redshift data lake analytics.

  • Adds the INTERVAL data type.

  • Adds CONTINUE_HANDLER, which is a type of exception handler that controls the flow of a stored procedure. Using it, you can catch and handle exceptions without ending the existing statement block.

  • Adds the ability to define permissions on a scope (schema or database) in addition to individual objects. This allows users and roles to be granted a permission on all current and future objects within the scope.

  • Adds the ability to create a database from a datashare with permissions that let consumer-side administrators grant individual permissions on shared database objects to consumer-side users and roles.

  • Adds support for the SUPER return data type from remote BYOM models. This expands the range of accepted SageMaker models to include those with more complex return formats.

  • Changes external functions to now implicitly cast numbers with or without fractional parts to the numeric data type of the column. For int2, int4, and int8 columns, numbers with fractional digits are accepted by truncating unless the number is out of range. For float4 and float8 columns, numbers are accepted without fractional digits.

  • Adds three spatial functions that work with the H3 hierarchical geospatial indexing grid system: H3_FromLongLat, H3_FromPoint, and H3_Polyfill.

Amazon Redshift patch 179

Cluster versions in this patch:

  • 1.0.62317 – Amazon Redshift Serverless version – Released on January 29, 2024

  • 1.0.62312 – Trailing track version – Released on January 29, 2024

  • 1.0.61631 – Amazon Redshift Serverless version – Released on January 5, 2024

  • 1.0.61626 – Current track version – Released on January 5, 2024

  • 1.0.61191 – Current track version – Released on December 16, 2023

  • 1.0.61150 – Amazon Redshift Serverless version – Released on December 16, 2023

  • 1.0.60982 – Amazon Redshift Serverless version – Released on December 13, 2023

  • 1.0.60854 – Current track version – Released on December 10, 2023

  • 1.0.60354 – Amazon Redshift Serverless version – Released on November 22nd, 2023

  • 1.0.60353 – Current track version – Released on November 21st, 2023

  • 1.0.60293 – Amazon Redshift Serverless version – Released on November 21st, 2023

  • 1.0.60292 – Current track version – Released on November 22nd, 2023

  • 1.0.60161 – Amazon Redshift Serverless version – Released on November 18th, 2023

  • 1.0.60140 – Current track version – Released on November 18th, 2023

  • 1.0.60139 – Amazon Redshift Serverless version – Released on November 18th, 2023

  • 1.0.59947 – Amazon Redshift Serverless version – Released on November 16th, 2023

  • 1.0.59945 – Current track version – Released on November 16th, 2023

  • 1.0.59118 – Amazon Redshift Serverless version – Released on November 9th, 2023

  • 1.0.59117 – Current track version – Released on November 9th, 2023

New features and improvements in this patch

  • Adds support so that federated users with appropriate permissions can view row-level security and dynamic data masking system views, including:

    • SVV_ATTACHED_MASKING_POLICY

    • SVV_MASKING_POLICY

    • SVV_RLS_ATTACHED_POLICY

    • SVV_RLS_POLICY

    • SVV_RLS_RELATION

  • Adds functionality such that a query that contains only scalar functions in the FROM clause now results in an error.

  • Adds CREATE TABLE AS (CTAS) statements with permanent target tables functionality to concurrency scaling clusters. Concurrency scaling clusters now support more queries.

  • Adds the following system tables to track table redistribution status after running classic resize on RA3 clusters:

    • The SYS_RESTORE_STATE system table shows table level redistribution progress.

    • The SYS_RESTORE_LOG system table shows historical throughput of data redistribution.

  • Improves slice skew minimizing on EVEN tables after running classic resize on RA3 node types. This is also applicable to patch 178 clusters that ran classic resize.

  • Adds support for UNLOAD with EXTENSION on concurrency scaling clusters.

  • Improves performance for queries that contain Λ UDFs in HashJoins and NestLoop joins.

  • Improves performance of Elastic Resize on RA3 node types.

  • Improves performance for data sharing queries.

  • Improves performance of manually initiated analyze queries in elastic-resized provisioned clusters and serverless workgroup.

  • Improves auto WLM query performance with better resource prediction in workload management.

  • Removes the functionality of launching clusters into dedicated tenancy VPCs. This change doesn't affect tenancy of any EC2 instances in the VPC. You can modify tenancy of your VPC to default with the modify-vpc-tenancy AWS CLI command.

  • Materialized view manual refresh is now supported on provisioned concurrency scaling clusters and serverless autoscaling compute.

  • Adds support for INTERVAL literals to the EXTRACT function. For example, EXTRACT('hours' from Interval '50 hours') returns 2 because 50 hours is interpreted as 2 days and 2 hours, and the hour component of 2 is extracted.

Amazon Redshift patch 178

Cluster versions in this patch:

  • 1.0.63327 - Current track version – Released on February 9, 2024

  • 1.0.63313 - Trailing track version – Released on February 9, 2024

  • 1.0.60977 - Trailing track version – Released on December 15, 2023

  • 1.0.59596 - Current track version – Released on November 9th, 2023

  • 1.0.58593 - Amazon Redshift Serverless version – Released on October 23rd, 2023

  • 1.0.58558 - Current track version – Released on October 23rd, 2023

  • 1.0.57864 - Current track version – Released on October 12th, 2023

  • 1.0.57850 - Amazon Redshift Serverless version – Released on October 12th, 2023

  • 1.0.56952 - Current track version – Released on September 25th, 2023

  • 1.0.56970 - Amazon Redshift Serverless version – Released on September 25th, 2023

New features and improvements in this patch

  • Amazon Redshift now has improved data sharing query performance by speeding up metadata refresh on consumer instances while concurrent data changes are happening on the producer instance.

  • Adds support for automatic and incremental refresh of materialized views on Amazon Redshift data sharing consumer instances when the base tables of the materialized view refer to the shared data.

  • Adds support for storing large objects up to 16 MB in size in the SUPER data type. When ingesting from JSON, PARQUET, TEXT, and CSV source files, you can load semi-structured data or documents as values in the SUPER data type, up to 16 MB.

  • Adds support for elastic resize for scaling to and from a single-node Amazon Redshift RA3 cluster.

  • Single-node Amazon Redshift RA3 clusters now can now benefit from encryption enhancements, reducing the overall encryption time and improving the availability of the data warehouse during the encryption process.

  • Improves support for queries when unnesting and unpivoting data stored in the SUPER data type.

  • Improves performance of refreshing materialized views with SUPER data types.

  • Adds support for aggregating INTERVAL literals with the ANY_VALUE function.

  • Streaming ingestion now supports the following new SQL command to purge streaming data: DELETE FROM streaming_materialized_views WHERE <where filter clause>.

  • The DECODE function replaces a specific value with either another specific value or a default value, depending on the result of an equality condition. DECODE now requires the following three parameters:

    • expression

    • search

    • result

  • Adds functionality to stored procedures to allow for catching data overflow data type conversion errors, and handling inside an exception-handling block.

  • You'll now receive an error when querying row-level security or dynamic data masking-protected relations if you change enable_case_sensitive_identifier to be different from the session default setting. Additionally, the following configuration is blocked when row-level security or dynamic data masking policies are applied in your provisioned cluster or serverless namespace:

    ALTER USER <current_user> SET case-sensitive identifier.

  • The MERGE command now supports a simplified syntax that only requires the target and source table. For more information, see MERGE in the Amazon Redshift Database Developer Guide.

  • Adds support for attaching identical dynamic data masking policies to multiple users or roles with the same priority, or without specifying the priority.

  • You can now specify a COLLATION when adding a new column through ALTER TABLE ADD COLUMN.

  • Fixes issue that delays the enforcement of QMR rules on concurrency scaling clusters and Amazon Redshift Serverless.

  • Amazon Redshift Federated Query has expanded pushdown support for timezone with timestamp on Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL.

  • You can now use Amazon RDS for MySQL and Aurora MySQL database names starting with digits with federated queries.

  • Adds the SYS_ANALYZE_HISTORY view, which contains record details for ANALYZE operations.

  • Adds the SYS_ANALYZE_COMPRESSION_HISTORY view, which contains record details for compression analysis operations during COPY or ANALYZE COMPRESSION commands.

  • Adds the SYS_SESSION_HISTORY view, which contains record details related to active, historical, and restarted sessions.

  • Adds the SYS_TRANSACTION_HISTORY view, which contains record details related to transaction level analysis that provides the time spent on commit, datasha number of blocks committed, and isolation level.

  • Adds the SVV_REDSHIFT_SCHEMA_QUOTA view, which contains records related to quotas and the current disk usage for each schema in a database.

  • Adds the SYS_PROCEDURE_CALL view, which contains records related to stored procedure calls, including start time, end time, status of the stored procedure call, and call hierarchy for nested stored procedure calls.

  • Adds the SYS_CROSS_REGION_DATASHARING_USAGE view, which contains records related to tracking cross-Region data sharing usage.

  • Adds the SYS_PROCEDURE_MESSAGES view, which contains records related to tracking information about logged stored procedure messages.

  • Adds the SYS_UDF_LOG view, which contains records related to tracking system log messages from user-defined function calls, errors, warnings, or traces when applicable.

  • Adds the new columns IS_RECURSIVE, IS_NESTED, S3LIST_TIME, and GET_PARTITION_TIME to SYS_EXTERNAL_QUERY_DETAIL.

  • Adds MaxRPU, a new compute cost control setting for Redshift Serverless. With MaxRPU, you can optionally specify an upper compute threshold to control data warehouse costs at different points in time by selecting the maximum compute level that Redshift Serverless can scale per workgroup.

  • Corrects the output of the INTERVAL literal with numeric interval strings. For example, an interval that specifies as INTERVAL '1' YEAR now returns 1 YEAR instead of "00:00:00. In addition, the output of the INTERVAL literal is truncated to the smallest INTERVAL component specified. For example, INTERVAL '1 day 1 hour 1 minute 1.123 seconds' HOUR TO MINUTE is truncated to 1 day 01:01:00.

Amazon Redshift patch 177

Cluster versions in this patch:

  • 1.0.57922 - Trailing track version – Released on October 12th, 2023

  • 1.0.57799 - Amazon Redshift Serverless version – Released on October 10th, 2023

  • 1.0.57798 - Current track version – Released on October 10th, 2023

  • 1.0.57085 - Trailing track version – Released on September 26th, 2023

  • 1.0.56899 - Amazon Redshift Serverless version – Released on September 21st, 2023

  • 1.0.56754 - Current track version – Released on September 21st, 2023

  • 1.0.56242 - Current track version – Released on September 11th, 2023

  • 1.0.55539 - Amazon Redshift Serverless version – Released on August 28th, 2023

  • 1.0.55524 - Current track version – Released on August 28th, 2023

  • 1.0.54899 - Current track version – Released on August 15th, 2023

  • 1.0.54899 - Current track version – Released on August 14th, 2023

  • 1.0.54899 - Current track version – Released on August 15th, 2023

  • 1.0.54239 - Current track version – Released on August 3rd, 2023

  • 1.0.54321 - Amazon Redshift Serverless version – Released on August 3rd, 2023

New features and improvements in this patch

  • Adds the SYS_MV_STATE view, which contains a row for every state transition of a materialized view. SYS_MV_STATE can be used for MV refresh monitoring for Amazon Redshift Serverless and Amazon Redshift provisioned instances.

  • Adds the SYS_USERLOG view, which records details for the changes to a database user for Create user, Drop user, Alter user (rename), Alter user (alter properties).

  • Adds the SYS_COPY_REPLACEMENTS view, which displays a log that records when invalid UTF-8 characters were replaced by the COPY command with the ACCEPTINVCHARS option.

  • Adds the SYS_SPATIAL_SIMPLIFY view, which contains information about simplified spatial geometry objects using the COPY command.

  • Adds the SYS_VACUUM_HISTORY view, which you can use to see the details and results of VACUUM operations.

  • Adds the SYS_SCHEMA_QUOTA_VIOLATIONS view to record the occurrence, timestamp, XID, and other useful information when a schema quota is exceeded.

  • Adds the SYS_RESTORE_STATE view, which you can use monitor the redistribution progress of each table in the cluster during asynchronous classic resize.

  • Adds the SYS_EXTERNAL_QUERY_ERROR view that return information about Redshift Spectrum scan errors.

  • Adds the tag parameter to the CREATE MODEL command, so you can now track training costs with autopilot training jobs.

  • Adds custom domain names (CNAME) for Amazon Redshift clusters.

  • Adds preview support for Apache Iceberg, enabling customers to run analytics queries on Apache Iceberg tables within Amazon Redshift.

  • Adds support for using user roles with parameter groups in workload management (WLM).

  • Adds support for automatic mounting of AWS Glue Data Catalog, making it easier for customers to run queries in their data lakes.

  • Adds functionality such that using grouping functions without a GROUP BY clause or using grouping operations in a WHERE clause results in an error.

  • Adds functionality to stored procedures to allow for catching divide by zero errors and handling inside a exception-handling block.

  • Fixes a bug that prevented queries from using concurrency scaling to write data to tables when the source table is a data sharing table.

  • Fixes the case-sensitive identifier documented at enable_case_sensitive_identifier to now work with MERGE statements.

  • Fixes the bug that a query on the function pg_get_late_binding_view_cols() might get ignored occasionally. You can now always cancel such queries.

  • Improves performance for data sharing queries running on consumers when running vacuum jobs on the producer.

  • Improves performance for data sharing and concurrency scaling queries, especially with concurrent data changes on the producer or when offloading to a concurrency scaling instance attached to the consumer.

Amazon Redshift patch 176

Cluster versions in this patch:

  • 1.0.56738 - Trailing track version – released on September 21st, 2023

  • 1.0.55837 - Trailing track version – released on September 11th, 2023

  • 1.0.54776 - Current track version – released on August 15th, 2023

  • 1.0.54052 - Current track version – Released on July 26th, 2023

  • 1.0.53642 - Amazon Redshift Serverless version – Released on July 20th, 2023

  • 1.0.53301 - Current track version – Released on July 20th, 2023

  • 1.0.52943 - Amazon Redshift Serverless version – Released on July 7, 2023

  • 1.0.52931 - Current track version – Released on July 7, 2023

  • 1.0.52194 - Amazon Redshift Serverless version – Released on June 21, 2023

  • 1.0.51986 - Current track version – Released on June 16, 2023

  • 1.0.51594 - Current track version – Released on June 9, 2023

New features and improvements in this patch

  • Improved error handling when writing GROUP BY () for an empty grouping set. This was ignored previously and now returns a parser error.

  • Performance enhancements for incrementally refreshing materialized views with SUPER columns.

  • ALTER TABLE <target_tbl> APPEND FROM <streaming_mv> – (ATA) SQL command now supports moving all records from a streaming materialized view (MV) as a source, in addition to tables as a source, to a target table. The support for ATA on streaming MVs allows users to rapidly purge all records in a streaming MV by moving them to another table to manage data growth.

  • TRUNCATE <streaming_mv> – SQL command now supports truncating all records in a streaming materialized view (MV), in addition to tables. TRUNCATE deletes all records in the streaming MV, while leaving the streaming MV structure intact. Running TRUNCATE on streaming MVs allows customers to rapidly purge all records in a streaming MV to manage data growth.

  • Added functionality for the QUALIFY clause to the SELECT command.

  • Redshift machine-learning support for time series forecasting by integrating with Amazon Forecast.

  • AWS Glue Data Catalog auto mounting is supported to simplify querying a data lake without extra steps to create external schema references.

  • Altering an RLS policy is now supported. Refer to the documentation for more details at ALTER RLS POLICY.

  • Lambda UDFs now support the STABLE function-volatility parameter in the CREATE FUNCTION statement. When the STABLE parameter is used in the CREATE FUNCTION statement and the Lambda UDF is called multiple times, with the same arguments, the expected number of Lambda UDF function invocations is decreased. The STABLE function volatility category is explained in more detail in the CREATE FUNCTION parameters.

  • Multiple Lambda UDF performance improvements. Specifically, improved record batching support when querying a table protected by a row-level security (RLS) policy.

  • Reduction in the overall encryption time for Amazon Redshift RA3 clusters and improvement in the availability of the data warehouse during encryption. For more information, see Amazon Redshift database encryption.

  • A new system view SYS_MV_REFRESH_HISTORY has been added to Redshift. The SYS_MV_REFRESH_HISTORY view contains a row for the refresh activity of materialized views. Using SYS_MV_REFRESH_HISTORY, you can check the refresh history of materialized views. SYS_MV_REFRESH_HISTORY is visible to all users. Superusers can see all rows; regular users can see only their own data.

    A new column SPILLED_BLOCK_LOCAL_DISK has been added to system view SYS_QUERY_DETAIL. The new column SPILLED_BLOCK_LOCAL_DISK helps customers to determine blocks spilled to local disk. You can use SYS_QUERY_DETAIL to view details for queries at a step level. SYS_QUERY_DETAIL is visible to all users. Superusers can see all rows; regular users can see only metadata to which they have access.

  • A new system view, SYS_QUERY_TEXT, has been added to Amazon Redshift Serverless and Amazon Redshift provisioned. The SYS_QUERY_TEXT view is similar to SVL_STATEMENTTEXT for provisioned clusters. Use the sequence column in the SYS_QUERY_TEXT view to get complete SQL statement text.

Amazon Redshift patch 175

Cluster versions in this patch:

  • 1.0.53064 - Current track version – Released on July 7, 2023

  • 1.0.51973 - Current track version – Released on June 16, 2023

  • 1.0.51781 - Current track version – Released on June 10, 2023

  • 1.0.51314 - Amazon Redshift Serverless version – Released on June 3, 2023

  • 1.0.51304 - Current track version – Released on June 2, 2023

  • 1.0.50708 - Current Track version – Released on May 19, 2023

  • 1.0.50300 - Current track version – Released on May 8, 2023

  • 1.0.49710 - Amazon Redshift Serverless version – Released on April 28, 2023

  • 1.0.49676 - Current track version – Released on April 28, 2023

New features and improvements in this patch

  • Minor bug fixes.

  • Amazon Redshift streaming ingestion now supports cross-region streaming ingestion where your source Amazon Kinesis Data Streams (KDS) or Amazon Managed Streaming for Apache Kafka (MSK) topic can be located in an AWS region that is different from the AWS region where your Amazon Redshift data warehouse is located. The documentation at Getting started with streaming ingestion from Amazon Kinesis Data Streams has been revised and explains how the REGION keyword is used.

  • Egypt daylight saving adjustment.

  • Improved overall times for encryption of RA3 clusters.

Amazon Redshift patch 174

1.0.51296 – Released on June 2, 2023

Release to trailing track. No release notes.

1.0.50468 – Released on May 12, 2023

Maintenance release. No release notes.

1.0.49780, 1.0.49868, and 1.0.49997 – Released on April 28, 2023

Release notes for this version:

  • Improved batching support for Lambda UDF.

  • Incremental batching for Lambda UDF.

  • New MERGE SQL command to apply source data changes to Amazon Redshift tables.

  • New dynamic data masking capability to simplify the process of protecting sensitive data in an Amazon Redshift data warehouse.

  • New centralized access control for data sharing with Lake Formation that allows managing permission grants, viewing access controls, and auditing permissions on the tables and views in the Amazon Redshift datashares using Lake Formation APIs and the AWS Console.

  • Egypt daylight saving adjustment.

1.0.49087 – Released on April 12, 2023

Maintenance release. No release notes.

1.0.48805 – Released on April 5, 2023

Release notes for this version:

  • Amazon Redshift introduced additional performance enhancements to string-heavy queries using BYTEDICT, a new compression encoding in Amazon Redshift that speeds up string-based data processing between 5x to 63x compared to alternative compression encodings such as LZO or ZSTD. For more information on this feature, see Byte-dictionary encoding in the Amazon Redshift Database Developer Guide.

1.0.48004 – Released on March 17, 2023

Maintenance release. No release notes.

1.0.47470 – Released on March 11, 2023

Release notes for this version:

  • Improves query performance on pg_catalog.svv_table_info. Also adds new column create_time. When creating a table, this column stores the date/time stamp in UTC.

  • Adds support for specifying session level timeout on federated query.

Amazon Redshift patch 173

1.0.49788 – Released on April 28, 2023

Release notes for this version:

  • Egypt daylight saving adjustment.

1.0.49074 – Released on April 12, 2023

Release notes for this version:

  • Timezone configuration updated to IANA library release 2022g.

1.0.48766 – Released on April 5, 2023

Maintenance release. No release notes.

1.0.48714 – Released on April 5, 2023

Maintenance release. No release notes.

1.0.48022 – Released on March 17, 2023

Maintenance release. No release notes.

1.0.47357 – Released on March 7, 2023

Maintenance release. No release notes.

1.0.46987 – Released on February 24, 2023

Maintenance release. No release notes.

1.0.46806 – Released on February 18, 2023

Maintenance release. No release notes.

1.0.46607 – Released on February 13, 2023

Release notes for this version:

  • We now automatically convert tables with manually set interleaved sort keys to compound sort keys if their distribution style has been set to DISTSTYLE KEY, to improve the performance of these tables. This is done at the time of restoring a snapshot into Amazon Redshift Serverless.

1.0.45698 – Released on January 20, 2023

Release notes for this version:

  • Adds a file extension parameter to the UNLOAD command, so file extensions are automatically added to filenames.

  • Supports protecting RLS-protected objects by default when adding them to a datashare or if they're already part of a datashare. Administrators can now turn off RLS for datashares to allow consumers access to the protected object.

  • Adds new system tables for monitoring: SVV_ML_MODEL_INFO, SVV_MV_DEPENDENCY, and SYS_LOAD_DETAIL. Also adds the columns data_skewness and time_skewness to the system table SYS_QUERY_DETAIL.

Amazon Redshift patch 172

Cluster versions in this patch:

  • 1.0.46534 – Released on February 18, 2023

  • 1.0.46523 – Released on February 13, 2023

  • 1.0.46206 – Released on February 1, 2023

  • 1.0.45603 – Released on January 20, 2023

  • 1.0.44924 – Released on December 19, 2022

  • 1.0.44903 – Released on December 18, 2022

  • 1.0.44540 – Released on December 13, 2022

  • 1.0.44126 – Released on November 23, 2022

  • 1.0.43980 – Released on November 17, 2022

New features and improvements in this patch

  • Tables created by CTAS are AUTO by default.

  • Adds support for row-level security (RLS) on materialized views.

  • Increases the S3 timeout to improve cross-Region data sharing.

  • Adds new spatial function ST_GeomFromGeohash.

  • Improves automatic selection of distribution key from composite primary keys to improve out-of-the-box performance.

  • Adds automatic primary key to distribution key for tables with composite primary keys, improving out-of-the-box performance.

  • Improves concurrency scaling to allow more queries to scale even as data changes.

  • Improves data sharing query performance.

  • Adds Machine Learning probability metrics for classification models.

  • Adds new system tables for monitoring: SVV_USER_INFO, SVV_MV_INFO, SYS_CONNECTION_LOG, SYS_DATASHARE_USAGE_PRODUCER, SYS_DATASHARE_USAGE_CONSUMER, and SYS_DATASHARE_CHANGE_LOG.

  • Adds support for querying VARBYTE columns in external tables for Parquet and ORC file types.

Amazon Redshift patch 171

Cluster versions in this patch:

  • 1.0.43931 – Released on November 16, 2022

  • 1.0.43551 – Released on November 5, 2022

  • 1.0.43331 – Released on September 29, 2022

  • 1.0.43029 – Released on September 26, 2022

New features and improvements in this patch

  • CONNECT BY support: Adds support for the CONNECT BY SQL construct, letting you recursively query the hierarchical data in your data warehouse based on parent-child relationship within that data set.

Amazon Redshift patch 170

Cluster versions in this patch:

  • 1.0.43922 – Released on November 21, 2022

  • 1.0.43573 – Released on November 7, 2022

  • 1.0.41881 – Released on September 20, 2022

  • 1.0.41465 – Released on September 7, 2022

  • 1.0.40325 – Released on July 27, 2022

New features and improvements in this patch

  • ST_GeomfromGeoJSON: Constructs an Amazon Redshift spatial geometry object from VARCHAR in GeoJSON representation.

Amazon Redshift patch 169

Cluster versions in this patch:

  • 1.0.41050 – Released on September 7, 2022

  • 1.0.40083 – Released on July 16, 2022

  • 1.0.39734 – Released on July 7, 2022

  • 1.0.39380 – Released on June 23, 2022

  • 1.0.39251 – Released on June 15, 2022

  • 1.0.39009 – Released on June 8, 2022

New features and improvements in this patch

  • Adds role as a parameter for the Alter Default Privileges command to support Role-based Access Control.

  • Adds ACCEPTINVCHARS parameter to support replacing invalid UTF-8 characters when copying from Parquet and ORC files.

  • Adds OBJECT(k,v) function to construct SUPER objects from key and value pairs.

Amazon Redshift patch 168

Cluster versions in this patch:

  • 1.0.38698 – Released on May 25, 2022

  • 1.0.38551 – Released on May 20, 2022

  • 1.0.38463 – Released on May 18, 2022

  • 1.0.38361 – Released on May 13, 2022

  • 1.0.38199 – Released on May 9, 2022

  • 1.0.38112 – Released on May 6, 2022

  • 1.0.37684 – Released on April 20, 2022

New features and improvements in this patch

  • Adds support for the Linear Learner model type in Amazon Redshift ML.

  • Adds SNAPSHOT option for SQL transaction isolation level.

  • Adds farmhashFingerprint64 as new hashing algorithm for VARBYTE and VARCHAR data.

  • Supports the AVG function in incremental refresh of materialized views.

  • Supports correlated sub-queries on external tables in Redshift Spectrum.

  • To improve the out-of-the-box query performance, Amazon Redshift automatically chooses a single column primary key for specific tables as a distribution key.