Posted On: Nov 26, 2023
Amazon Redshift provisioned cluster concurrency scaling and serverless autoscaling now supports CREATE TABLE AS SELECT (CTAS) queries. This allows customers to scale their extract, transform, and load (ETL) and other write workloads with additional compute to more easily meet their SLAs.
Amazon Redshift provisioned cluster concurrency scaling and serverless autoscaling is leveraged by thousands of customers to support virtually unlimited concurrent users and queries, and meet their SLAs for BI reports, dashboards, ETL, and other analytics workloads. With the new capability, customers who currently use provisioned cluster concurrency scaling and serverless autoscaling can scale CTAS operations. CTAS works seamlessly with any configured usage controls and workload management queue configurations. When concurrency scaling is enabled for a queue, all eligible queries can be sent to concurrency scaling clusters without having to wait for resources to free up on the main Amazon Redshift cluster. Each Amazon Redshift provisioned cluster earns up to one hour of free Concurrency Scaling credits per day. This seamlessly works with CTAS as well. For any usage that exceeds the accrued free usage credits, customers are billed on a per-second basis based on the on-demand rate of their Amazon Redshift cluster and according to the cost controls configured.
Provisioned cluster concurrency scaling and serverless auto scaling support for CTAS is generally available in 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.