How to enable HttpEndpoint in Aurora Serverless v2

Unfortunately, you can't use the Data API with Aurora Serverless v2 as mentioned in this documentation page: HttpEndpoint is not enabled for cluster <cluster_ID>

As you can read in this other answer, AWS support searched internally, and there's a feature request on file, but it still needs to be released. Please get in touch with your AWS Account team so they can keep track of the feature request and register your interest.

If the answer is helpful, please click "Accept Answer" and upvote it.

Hi, yes, HttpEndpoint is automatically enabled in Aurora serverless v2. So, you might have a connectivity issue to it.

You should follow guidance of section "Verify your connection to the Aurora endpoint" in https://repost.aws/knowledge-center/troubleshoot-connecting-aurora by telneting it from you laptop. If you can't connect, you te secgroup protecting the http endpoint is probably the blocker (allowed source addresses or tcp port)

See https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Overview.RDSSecurityGroups.html

and

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_SettingUp_Aurora.html#CHAP_SettingUp_Aurora.SecurityGroup

You will have to adapt it for allowing first your laptop then your lambdas by allowing the addresses of the vpc to which they are attached. When working on your laptop and lambdas, you can remove the secgroup rules corresponding to the laptop.

To more easily debug the problem from the vpc of your lambdas, you may want to start an EC2 on this vpc and connect to it via ssh to be able to use telnet, etc. to debug efficiently.