Access Secrets using VPC EndPoint in Kafka Event-source in EventBridge Pipes

**Scenario: **

• MSK Cluster is in private subnet of VPC-1 and I am trying to create an EventBridge Pipe in VPC2 that gets data from the MSK cluster
• VPC-1 and VPC-2 are connected using VPC peering
• Kafka authentication details are stored in Secrets Manager
• I am using "Self managed Apache Kafka" for Event source as both VPCs are in differet AWS accounts.

It works if I configure NAT gateway in VPC2. Is it possible to achieve the same functionality using VPC Endpoints?

Problem

• I have deleted NAT gateway and I have created VPC endpoint for Secrets Manager as Event Source will need to access Kafka authentication information.
• Also, added STS VPC endpoint
• This setup fails to start the EventBridge Pipe with error message "PROBLEM: Pipe VPC event source require outbound internet access to send events to Pipes"