You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by "Kaxil Naik (JIRA)" <ji...@apache.org> on 2019/01/12 15:49:00 UTC
[jira] [Resolved] (AIRFLOW-3676) Additional permission is needed
for Export/Import example of Google Cloud SQL operator
[ https://issues.apache.org/jira/browse/AIRFLOW-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kaxil Naik resolved AIRFLOW-3676.
---------------------------------
Resolution: Fixed
Fix Version/s: 1.10.2
> 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
> Fix For: 1.10.2
>
>
> 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)