Please follow the instructions on connecting with a service account using Cloud SQL proxy.

A few things to note:

Google Cloud SQL Admin API

The Google Cloud SQL Admin API must be enabled. We don't perform admin actions, but this is a requirement for any proxy-based access including read-only.

Service account access

Please give the service account faraday-incoming@production-237317.iam.gserviceaccount.com the IAM permission "Cloud SQL client". This only allows us to connect to the proxy, but does not allow us any database permissions.

Database username and password

Once we have connected to your instance using Cloud SQL Proxy, we still need a normal Postgres user to access your tables. Please set one up, possibly with read-only access.

See What data Faraday expects for more information.

Setup

Create a new Source on https://app.faraday.io/sources, select Google Cloud SQL Postgres as a Source type, and add the listed properties:


Did this answer your question?