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
firstname.lastname@example.org 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.
Create a new Source on https://app.faraday.io/sources, select Google Cloud SQL Postgres as a Source type, and add the listed properties: