Redshift connection fails

Hello,

could you please look into solution it will be helpful to you.

Check Security Group: Ensure that your Redshift cluster's security group allows inbound traffic on port 5439 from the IP address or range where your Python shell jobs are running.

Verify Public Accessibility: Double-check that your Redshift cluster is set to publicly accessible in the AWS Redshift console.

Confirm Endpoint: Use the correct endpoint for your Redshift cluster in your connection string.

Test Connectivity: Attempt to connect to your Redshift cluster using a database client like DBeaver or psql from the same network where your Python shell jobs are running to confirm if the issue is specific to your Python environment.

Check VPC and Subnet Configuration: Ensure that your VPC has an internet gateway configured in its route table, and if your Redshift cluster is in a private subnet, confirm that it has a NAT Gateway or NAT Instance for outbound internet access.

here if you get more information go through the AWS Documents Link. https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-refusal-failure-issues.html https://docs.aws.amazon.com/redshift/latest/mgmt/troubleshooting-connections.html