No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.

Pulumi Community

The only workaround with Pulumi would be to use a DB proxy and connect via the public IP without connecting the instances, but I'd rather avoid it and do things properly...

Indeed it seems how to affect the internal cloud SQL proxy from the API is not documented

But you can use a vpc connector and connect directly to the private IP, I normally prefer to not use their proxy because although it is more practical it adds a few millisecond, which is not desirable to a very latency sensitive application (our case)

<https://cloud.google.com/run/docs/configuring/connecting-vpc#yaml|https://cloud.google.com/run/docs/configuring/connecting-vpc#yaml>

Create the connector on the same region and add the annotation

I've done this exact thing, let me review my stack...

the `DatabaseInstance` has a `ConnectionName` output property. You need to set an annotation in the cloud run service's `Template.Metadata.Annotations` with a key of `<http://run.googleapis.com/cloudsql-instances|run.googleapis.com/cloudsql-instances>` and a value of that `ConnectionName` property from the database instance. Then (i assume) you'll also need to pass a connection string to your app. In my case, I'm using Postgres, so my app's connection string looks like this (params in curly braces): `Host=/cloudsql/{dbStack.CloudSqlConnectionName};Username={dbStack.Username};Password={dbStack.Password};` .

I guessed it would be something on that line. But I haven't found the annotation on the docs.

I was about to look into the gcloud source to see how the flag affects the resource

I used the terraform docs to figure out how to set up the cloud sql instance annotation:
<https://www.terraform.io/docs/providers/google/r/cloud_run_service.html>

Thanks <@USC68LB3J> and <@U012ETM7M4P>, I'm going to give it a try today

<@U012ETM7M4P> the annotation following terraform example worked! Thanks :slightly_smiling_face: