1. Identify Unused Reserved Nodes:
   • Go to the AWS Management Console and navigate to the Amazon Redshift dashboard.
   • Click on the “Clusters” tab to view the list of Redshift clusters in your account.
   • Look for any Reserved Nodes that are marked as “Unused” or have low utilization.
2. Modify or Exchange Reserved Nodes:
   • Select the unused Reserved Node that you want to modify or exchange.
   • Click on the “Actions” dropdown menu and choose the “Modify” or “Exchange” option.
   • If you choose to modify the Reserved Node, you can adjust the node type or the number of nodes to better match your current usage requirements.
   • If you choose to exchange the Reserved Node, you can select a different Reserved Node with specifications that better fit your needs.
3. Apply Changes:
   • Review the changes you have made to the Reserved Node configuration.
   • Click on the “Apply Changes” button to save the modifications or exchanges.
4. Monitor Utilization:
   • Regularly monitor the utilization of your Redshift clusters to ensure that the Reserved Nodes are being effectively utilized.
   • Adjust the Reserved Node configurations as needed to optimize cost savings and performance.

​

1. List all the existing Reserved Nodes in Redshift:

aws redshift describe-reserved-nodes

2. Identify the Reserved Nodes that are currently unused or underutilized based on their utilization metrics.
3. Modify the Reserved Nodes to match the actual usage or delete them if they are no longer needed. You can modify a Reserved Node to a different node type or change the number of nodes using the following command:

aws redshift modify-reserved-node --reserved-node-id <ReservedNodeId> --node-type <NewNodeType> --node-count <NewNodeCount>

4. If the Reserved Nodes are no longer needed, you can delete them using the following command:

aws redshift delete-reserved-node --reserved-node-id <ReservedNodeId>

5. Monitor the Redshift clusters to ensure that the Reserved Nodes are now being utilized effectively.

1. Install Boto3: Ensure you have Boto3 installed in your Python environment. You can install it using pip:

pip install boto3

2. Create a Python Script: Create a Python script (e.g., remediate_redshift_reserved_nodes.py) and import the necessary libraries:

import boto3

3. Initialize Boto3 Client: Initialize the Boto3 client for Redshift:

client = boto3.client('redshift')

4. List Reserved Nodes: Use the describe_reserved_nodes method to list all the reserved nodes in your Redshift cluster:

response = client.describe_reserved_nodes()
reserved_nodes = response['ReservedNodes']

5. Identify Unused Reserved Nodes: Loop through the reserved nodes to identify any unused nodes. You can check if the NodeCount is 0 or if the node is not associated with any cluster:

for node in reserved_nodes:
    if node['NodeCount'] == 0 or not node['ClusterIdentifier']:
        # Add remediation steps here

6. Modify or Delete Unused Nodes: Depending on your requirements, you can choose to modify the unused nodes (e.g., associate them with a cluster) or delete them. Below are the steps to modify the node and associate it with a cluster:

# Modify the unused node and associate it with a cluster
node_id = node['ReservedNodeId']
cluster_id = 'your_cluster_id'

client.modify_reserved_node(
    ReservedNodeOfferingId=node['ReservedNodeOfferingId'],
    ReservedNodeId=node_id,
    TargetReservedNodeOfferingId=node['ReservedNodeOfferingId'],
    TargetNodeType=node['NodeType'],
    TargetNumberOfNodes=node['NodeCount'],
    ClusterIdentifier=cluster_id
)

7. Run the Script: Save the script and run it to identify and remediate the unused Redshift Reserved Nodes:

python remediate_redshift_reserved_nodes.py