/solved
Alas as soon as you ask for help you discover the issue.
If you're using Cloud SQL Proxy locally the hostname is localhost/127.0.0.1, in Cloud run the hostname is /cloudsql/INSTANCE_CONNECTION_NAME.
/cloudsql/INSTANCE_CONNECTION_NAME