[
https://issues.apache.org/jira/browse/AIRFLOW-6855?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17061154#comment-17061154
]
ASF subversion and git services commented on AIRFLOW-6855:
----------------------------------------------------------
Commit 894d41c64b4fe9eef6c89f3fc310c41ff8835fdf in airflow's branch
refs/heads/v1-10-test from Kaxil Naik
[ https://gitbox.apache.org/repos/asf?p=airflow.git;h=894d41c ]
[AIRFLOW-6855] Escape project_dataset_table in SQL query in gcs to bq operator
(#7475)
cherry-picked from 0de0347b27a961c46ee49da6dfa9205321657749
Co-Authored-By: Moira Tagle <[email protected]>
> GCS to BQ load will fail with syntax error if specified project has a - in it
> -----------------------------------------------------------------------------
>
> Key: AIRFLOW-6855
> URL: https://issues.apache.org/jira/browse/AIRFLOW-6855
> Project: Apache Airflow
> Issue Type: Bug
> Components: gcp
> Affects Versions: 1.10.9
> Reporter: Moira Tagle
> Assignee: Moira Tagle
> Priority: Minor
> Fix For: 1.10.10
>
>
> If you try to run a GCS -> BQ load that explicitly specifies a destination
> project that contains a -, the sql that runs to emit the final log message:
> SELECT MAX(\{id}) FROM \{project_dataset_table}
> will fail because the - in the project is not escaped in the SQL.
> datasets and tables cannot have - in them, and if you are implicitly getting
> the project from the configured connection it will not explicitly be in the
> SQL, so this is only a problem if the project is explicitly specified and it
> has a - in it.
> To fix this, the project_dataset_table should be escaped in the SQL query.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
