[ 
https://issues.apache.org/jira/browse/AIRFLOW-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Jarek Potiuk reassigned AIRFLOW-3676:
-------------------------------------

    Assignee: Jarek Potiuk

> 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
>            Assignee: Jarek Potiuk
>            Priority: Major
>
> 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)

Reply via email to