View a markdown version of this page

Resizing a Multi-AZ data warehouse - Amazon Redshift

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

Resizing a Multi-AZ data warehouse

You can resize a Multi-AZ data warehouse and specify a number of nodes or node type that is different from the current configuration of the data warehouse.

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshiftv2/.

  2. On the navigation menu, choose Provisioned clusters dashboard, and choose Clusters. The clusters for your account in the current AWS Region are listed. A subset of properties of each cluster is displayed in columns in the list.

  3. Choose the cluster you want to resize the Multi-AZ data warehouse. The cluster details page appears.

  4. For Actions, choose Resize. The Resize cluster page appears.

  5. Follow the instructions on the page. You can resize the cluster now, once at a specific time, or increase and decrease the size of your cluster on a schedule.

  6. Under New configurations, choose one of the RG or RA3 node types from the Node type drop-down list.

  7. Click Resize cluster.

To resize a Multi-AZ data warehouse using the AWS Command Line Interface
  • From the AWS CLI, use the resize-cluster command to change the number of nodes for a single Availability Zone as follows.

    aws redshift resize-cluster \ --cluster-identifier test-maz-11 --cluster-type multi-node --node-type rg.4xlarge --number-of-nodes 6