Posted On: Nov 15, 2022

Amazon Redshift concurrency scaling is leveraged by thousands of customers to support virtually unlimited concurrent users and queries, and meet their SLAs for BI reports, dashboards and other analytics workloads. In addition to the read queries, Amazon Redshift concurrency scaling is now extended to support scaling of most common write operations performed as part of workloads such as data ingestion and processing. The write workloads support with concurrency scaling is available on Amazon Redshift RA3 instance types.

With the new capability, customers who currently use concurrency scaling can automatically scale common write operations such as Redshift COPY, INSERT, UPDATE, DELETE on to the concurrency scaling clusters. The write workloads support works seamlessly with any configured usage controls and workload management queue configurations. When concurrency scaling is enabled for a queue, eligible write queries are sent to concurrency scaling clusters without having to wait for resources to free up on the main Amazon Redshift cluster. The hourly credits that customers accrue with concurrency scaling for every 24 hours of their usage of the main Amazon Redshift cluster can be leveraged to support scaling write queries as well. For any usage that exceeds the accrued free usage credits, you will be billed on a per-second basis based on the on-demand rate of their Amazon Redshift cluster and according to the cost controls configured. 

Concurrency scaling support for write workloads is generally available all Amazon Redshift regions where RA3 instance types and concurrency scaling are supported. For more information on concurrency scaling refer to our documentation in the Amazon Redshift Cluster Developer Guide.