Authentication for cloudsql instance

[amishas157]

What problem does your feature solve?

Currently cloud sql instance has two ways of authentication

1. Using host 34.122.97.123, user =postgres, password = postgres. In this method, we have to add IP of the client to allowlist so that client can authenticate
2. Using a service account

What would you like to see?

As far as I know:

• Ledger data indexer uses option 1. for auth. We need to change it to use service account.
• DevX team uses both means of authentication. We need to change it to use only service account.

What alternatives are there?

[travertischio]

One the password hard coded in the ledger data indexer was removed #3 , using the cloudsql proxy was pretty straightforward. The testnet dev environment is working using IAM service accounts with no passwords