[
https://issues.apache.org/jira/browse/AIRFLOW-1556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rajiv Bharadwaja updated AIRFLOW-1556:
--------------------------------------
Description:
BigQuery supports running parameterized queries:
https://cloud.google.com/bigquery/docs/parameterized-queries
Bigquery API support for SQL parameters was added to the api late last year:
https://github.com/GoogleCloudPlatform/google-cloud-python/pull/2776).
Airflow's bigquery_hook.py and bigquery_operator.py do not support this yet.
https://github.com/apache/incubator-airflow/commits/master/airflow/contrib/hooks/bigquery_hook.py
https://github.com/apache/incubator-airflow/commits/master/airflow/contrib/operators/bigquery_operator.py
SQL parameter support is different from the jinja templating / airflow macro
support for parameterizing query strings; the latter works at the query string
level.
was:
Bigquery API support for SQL parameters was added to the api late last year:
https://github.com/GoogleCloudPlatform/google-cloud-python/pull/2776).
Airflow's bigquery_hook.py and bigquery_operator.py do not support this yet.
https://github.com/apache/incubator-airflow/commits/master/airflow/contrib/hooks/bigquery_hook.py
https://github.com/apache/incubator-airflow/commits/master/airflow/contrib/operators/bigquery_operator.py
SQL parameter support is different from the jinja templating / airflow macro
support for parameterizing query strings; the latter works at the query string
level.
> BigQueryBaseCursor should support SQL parameters
> ------------------------------------------------
>
> Key: AIRFLOW-1556
> URL: https://issues.apache.org/jira/browse/AIRFLOW-1556
> Project: Apache Airflow
> Issue Type: Bug
> Components: contrib
> Reporter: Rajiv Bharadwaja
> Assignee: Rajiv Bharadwaja
> Priority: Minor
> Labels: newbie
> Original Estimate: 72h
> Remaining Estimate: 72h
>
> BigQuery supports running parameterized queries:
> https://cloud.google.com/bigquery/docs/parameterized-queries
> Bigquery API support for SQL parameters was added to the api late last year:
> https://github.com/GoogleCloudPlatform/google-cloud-python/pull/2776).
> Airflow's bigquery_hook.py and bigquery_operator.py do not support this yet.
> https://github.com/apache/incubator-airflow/commits/master/airflow/contrib/hooks/bigquery_hook.py
> https://github.com/apache/incubator-airflow/commits/master/airflow/contrib/operators/bigquery_operator.py
> SQL parameter support is different from the jinja templating / airflow macro
> support for parameterizing query strings; the latter works at the query
> string level.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
