Lambda access to Redshift - connection time out

Question

I have created a lambda function using redshift_connector to read data from S3 bucket in another AWS account, and write data into Redshift account (Lambda is in the same account with my Redshift cluster). Redshift is in a private subnet and is not publicly accessible.

The Python code works in the local environment. But it has error **"('connection time out', TimeoutError(110, 'Connection timed out'))"** when I run it in the Lambda.

I configured the VPC to be in the same VPC as Redshift, and selected two private subnets in Lambda VPC setting. I also granted the AWSLambdaVPCAccessExecutionRole and AmazonRedshiftDataFullAccess to the role used by Lambda but I still have the same issue. Is there anything else that need to be configured? Thanks in advance for the help!

Accepted Answer

If your Lambda and Redshift are in the same VPC, you should check:

- that the security group associated with your Redshift cluster allows inbound traffic from the Lambda function. You can do this by allowing inbound traffic on the port Redshift is using (default is `5439`) from the security group associated with your Lambda function.
- the network access control lists (ACLs) for the subnets to ensure they are not blocking traffic between your Lambda function and the Redshift cluster. Network ACLs can be configured to allow or deny traffic based on IP address, port, and protocol.

**Key sources:**
- [Networking 101 - Part 2 (Security Components)](https://repost.aws/articles/ARgs1iWM-ASlGSktYepaY68Q/networking-101-part-2?sc_ichannel=ha&sc_ilang=en&sc_isite=repost&sc_iplace=hp&sc_icontent=ARgs1iWM-ASlGSktYepaY68Q&sc_ipos=6)

Lambda access to Redshift - connection time out

Contenido relevante