Redshift Reserved Node Should Not Have Status - Payment Pending
More Info:
Ensure that none of your AWS Redshift Reserved Node purchases are pending.Risk Level
LowAddress
Cost OptimisationCompliance Standards
CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the issue of a Redshift Reserved Node having a status of “Payment Pending” in AWS, you can follow these steps using the AWS Management Console:
- Navigate to the Redshift Console: Go to the AWS Management Console and navigate to the Amazon Redshift service.
- Identify the Reserved Node: In the Redshift console, select the “Clusters” option from the left-hand menu. Identify the Redshift cluster that has the Reserved Node with the status of “Payment Pending”.
- Check Reserved Nodes: In the cluster details page, navigate to the “Reserved Nodes” tab to view the list of Reserved Nodes associated with the cluster.
- Identify the Payment Pending Node: Look for the Reserved Node that has a status of “Payment Pending”.
- Modify the Reserved Node: Select the Reserved Node with the “Payment Pending” status and choose the “Modify” option.
- Complete the Payment: Follow the prompts to complete the payment for the Reserved Node. Ensure that the payment method associated with your AWS account has sufficient funds or is valid for payment.
- Confirm the Status Change: Once the payment is completed successfully, the status of the Reserved Node should change from “Payment Pending” to “Active” or “Payment Complete”.
- Verify the Status: Go back to the list of Reserved Nodes associated with the cluster and verify that the status of the Reserved Node has been updated.
Using CLI
Using CLI
To remediate the misconfiguration of a Redshift Reserved Node having the status “Payment Pending” in AWS using AWS CLI, you can follow these steps:Replace After following these steps, the Redshift Reserved Node should no longer have the status “Payment Pending” and should be active.
- List the Redshift Reserved Nodes to identify the one with the status “Payment Pending”:
- Identify the Reserved Node ID of the node with the status “Payment Pending”.
- Modify the Reserved Node to change the payment status to “active” using the following command:
<ReservedNodeID>, <ReservedNodeOfferingID>, and <NewReservedNodeOfferingID> with the actual values of the Reserved Node ID, the current Reserved Node Offering ID, and the new Reserved Node Offering ID respectively.- Check the status of the Reserved Node to ensure it has been updated successfully:
Using Python
Using Python
To remediate the misconfiguration of a Redshift Reserved Node having a status of “Payment Pending” in AWS using Python, you can follow these steps:
- Install the Boto3 library:
- Use the following Python script to check the status of the Redshift Reserved Nodes and modify the status if it is “Payment Pending”:
- Run the Python script, and it will check the status of all the Redshift Reserved Nodes. If it finds any node with a status of “Payment Pending”, it will modify the status to “Active”.