Thanks ms4446 for providing the details. The use case is for tableau clients deployed in other GCP projects belonging to the same organization.
I set up a Cloudsql database with PSC enabled by passing the parameter “–enable-private-service-connect”, the grabbed the service attachment link off the instance
(pscServiceAttachmentLink)
Then created the Private Service Connect endpoint and pointed it to the Cloud SQL service attachment. This worked for clients that were located in subnets within the same region as the PSC endpoint, if the client was located in a subnet of a different region, then it failed to connect. Is this a limitation? Please advise.
PS - No VPC peering was necessary when using the PSC endpoint