1. Navigate to the AWS Redshift Console:
   • Go to the AWS Management Console (https://aws.amazon.com/console/).
   • In the “Find Services” search bar, type “Redshift” and select “Amazon Redshift” from the options.
2. Access the Reserved Nodes Dashboard:
   • In the Amazon Redshift console, navigate to the “Clusters” section from the left-hand menu.
   • Click on the “Reserved Nodes” tab to view the list of reserved nodes.
3. Identify Reserved Nodes with Payment Failed Status:
   • Look for the reserved nodes that have a status of “Payment Failed” in the list of reserved nodes.
4. Modify the Reserved Node:
   • Select the reserved node with the “Payment Failed” status by clicking on it.
   • Click on the “Modify” button to edit the reservation.
5. Update Payment Information:
   • In the modification form, update the payment information associated with the reserved node.
   • Ensure that the payment method linked to the reserved node is valid and has sufficient funds to cover the reservation.
6. Save Changes:
   • After updating the payment information, click on the “Save” or “Apply Changes” button to confirm the modifications.
7. Verify Status:
   • Once the changes are saved, verify that the status of the reserved node has been updated to a valid state (e.g., “Active”).
8. Monitor and Confirm:
   • Monitor the status of the reserved node over the next few minutes to ensure that the changes are successfully applied.
   • Confirm that the reserved node no longer shows a status of “Payment Failed.”

​

1. Identify the Reserved Node with Payment Failed status: Use the following AWS CLI command to list all the Redshift Reserved Nodes and their statuses:
   aws redshift describe-reserved-nodes
   
   Look for the Reserved Node(s) with the “Payment Failed” status.
2. Modify the Reserved Node: Use the following AWS CLI command to modify the Reserved Node with the Payment Failed status:
   aws redshift modify-reserved-node --reserved-node-id <ReservedNodeId> --reserved-node-offering-id <NewReservedNodeOfferingId>
   
   Replace <ReservedNodeId> with the ID of the Reserved Node with Payment Failed status and <NewReservedNodeOfferingId> with the ID of a new Reserved Node offering that you want to apply.
3. Confirm the modification: Use the following AWS CLI command to confirm the modification and apply the changes:
   aws redshift purchase-reserved-node-offering --reserved-node-offering-id <NewReservedNodeOfferingId>
   
   Replace <NewReservedNodeOfferingId> with the ID of the new Reserved Node offering that you specified in step 2.
4. Verify the status: Use the following AWS CLI command to verify that the Reserved Node status has been updated:
   aws redshift describe-reserved-nodes
   
   Check if the Reserved Node status is now updated and no longer shows “Payment Failed”.

1. Install Boto3: If you haven’t already installed Boto3, you can do so using pip:
   pip install boto3
   
2. Configure AWS Credentials: Make sure you have your AWS credentials configured either through environment variables, shared credentials file, or AWS config file.
3. Write Python Script: Create a Python script with the following code to identify and update the status of Redshift Reserved Nodes with “Payment Failed” status:
   import boto3
   
   # Initialize the Redshift client
   redshift_client = boto3.client('redshift')
   
   # Describe reserved nodes to get the list of reserved nodes
   response = redshift_client.describe_reserved_nodes()
   
   for reserved_node in response['ReservedNodes']:
       if reserved_node['State'] == 'payment-failed':
           # Modify the status of the reserved node
           redshift_client.modify_reserved_node(
               ReservedNodeId=reserved_node['ReservedNodeId'],
               ReservedNodeOfferingType=reserved_node['OfferingType'],
               NodeCount=reserved_node['NodeCount'],
               NodeType=reserved_node['NodeType'],
               Duration=reserved_node['Duration'],
               OfferingType=reserved_node['OfferingType'],
               PaymentOption='ALL_UPFRONT'
           )
           print(f"Successfully updated the status of Reserved Node {reserved_node['ReservedNodeId']}")
   
   
4. Run the Script: Execute the Python script to identify Redshift Reserved Nodes with “Payment Failed” status and update their status to “ALL_UPFRONT” payment option.
   python remediate_redshift_reserved_nodes.py