[jira] [Created] (AIRFLOW-3676) Additional permission is needed for Export/Import example of Google Cloud SQL operator

["Jarek Potiuk (JIRA)" <ji...@apache.org>]

Jarek Potiuk created AIRFLOW-3676:
-------------------------------------

             Summary: Additional permission is needed for Export/Import example of Google Cloud SQL operator
                 Key: AIRFLOW-3676
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-3676
             Project: Apache Airflow
          Issue Type: Improvement
            Reporter: Jarek Potiuk


There is an extra permission needed (Write! to bucket) in order to run Import operation for Google Cloud SQL. It might sounds pretty non-obvious to need a write permission when you import data from GCP bucket, but this is how it is required. It's not well documented but you can find it in description here:

[https://cloud.google.com/sql/docs/mysql/import-export/importing#csv-reqs]

(Click on the GCLOUD (2ND GEN)) and you will see that you need it:

 
 # Add the service account to the bucket ACL as a writer:
 
gsutil acl ch -u [SERVICE_ACCOUNT_ADDRESS]:W gs://[BUCKET_NAME]
 # Add the service account to the import file as a reader:
 
gsutil acl ch -u [SERVICE_ACCOUNT_ADDRESS]:R gs://[BUCKET_NAME]/[IMPORT_FILE_NAME]

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)