ERROR: (gcloud.sql.instances.create) User [airflow-deploy-svc-account@XXX.iam.gserviceaccount.com] does not have permission to access project XXX

[kenhglee]

Hi!

Thank you for sharing this git repository! While running the "docker-compose -f deploy/gke/docker-compose-gke.yml up" command, I hit upon the above mentioned error complaining there is no access to my current project on the part of the service account.

I went on to check that the service account indeed has the access.

gcloud projects get-iam-policy XXX
--flatten="bindings[].members"
--format='table(bindings.role)'
--filter="bindings.members:airflow-deploy-svc-account@gcp-dpe.iam.gserviceaccount.com"

yields
ROLE
roles/cloudsql.admin (I added this to see if it makes any difference.)
roles/owner

Could you please advise what could it have possibly gone wrong?