After getting some help from AWS, I was able to create a connection. Here is what was recommended for the above setup. Add SecretsManagerReadWrite to IAM role.

Add the following VPC endpoints to the VPC and subnet where your Redshift cluster is configured:

• S3 (Gateway type)
• STS (Interface type)
• Secrets Manager (Interface type)
• Redshift (Interface type)