We want to configure Postgres Datasource for querying our Postgres DB hosted on GCPs CloudSQL. We usually use IAM service accounts for authentication purposes. However, Postgres datasource expects both password and username to be configured. As I cannot leave password field empty, I enter some random string to password filed. It is giving me authentication failed in this case.
Appreciate in advance any advice how to set this up, and if this setup is even possible.