Forbidden: Authenticated IAM principal does not seem authorized to make API request. Verify ‘Cloud SQL Admin API’ and ‘Cloud SQL Client’ role
I have an Airflow cluster on Kubernetes, maintained by the SRE team. The cluster uses the service account sa_project_a, created from project_a, to authenticate and access the GCP project. I need to implement a Python script to ingest data from BigQuery in project_a and project_b then write the data to a MySQL database hosted on Cloud SQL in project_b.