I am running a RDS instance which is running under a VPC. I have a lambda which connects to RDS instance for read/write operations. Now I want to assign lambda in same VPC so that it is able to connect with RDS but I don't want my lambda to have public access.
Now, I want to define a public API endpoint using API gateway which can connect to my private lambda inside a VPC. I have read multiple articles and AWS documentation but could not get the exact steps to achieve that. Is that possible? Thanks for any pointers in advance.