How to connect Dagster storage to Google Cloud SQL

[dagsir[bot]]

Hi all. I am testing deploying Dagster via Google Cloud Run. I have a Cloud SQL PostgreSQL instance and Dagster runs well when I run it locally using the instance's public IP as my host for PostgresRunStorage, PostgresEventLogStorage, and PostgresScheduleStorage. For production via Cloud Run, I want my Cloud Run instance to use the built-in connector for Cloud SQL. This provides a unix socket that should be used as the host (ie. /cloudsql/GCP_PROJECT:us-central1:CLOUD_SQL_INSTANCE_NAME). Using that unix socket path in the host field does not work. I believe that's because I need to use a different format for the connection string than what I see being used. I am looking for guidance on how I should proceed from here. Thank you!

---

The question was originally asked in Dagster Slack.

[yuhan]

You can also construct the url yourself and set it as ‘postgres_url’, see one of the examples here: https://docs.dagster.io/deployment/dagster-instance#postgres-storage