This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
On a GCP Project, there is a Cloud SQL DataBase (PostgreSQL). A service account is associated to this Cloud SQL DataBase (since its creation I guess). My problem is that I don't see this service account among the 11 other service accounts in the IAM UI... So I can't add a Role to it...
I have to grant this service account accessibility to a bucket, because I want to import in the database, datas from a CSV file downloaded in that bucket.
When I try to import a file using API or gcloud command (gcloud sql import csv), this is the error I get :
ERROR: (gcloud.sql.import.csv) HTTPError 403: The service account does not have the required permissions for the bucket.
So I would like to find the service account associated to the Cloud SQL database, in order to grant it roles/storage.objectAdmin. Is there a trick in this case ?
I've found a workaround in order to grant the required role to the instance service account (which still can't be found in IAM). I've just import manually a CSV from the import UI of Cloud SQL. That action grants automatically the required roles (roles/storage.objectAdmin) to the instance service account.
I'm now able to import files in the DB using API calls or GCLOUD command line.
I've found a workaround in order to grant the required role to the instance service account (which still can't be found in IAM). I've just import manually a CSV from the import UI of Cloud SQL. That action grants automatically the required roles (roles/storage.objectAdmin) to the instance service account.
I'm now able to import files in the DB using API calls or GCLOUD command line.
LinkedIn
Twitter
