[jira] [Created] (AIRFLOW-3792) Bigquery hook no longer accepts queryParameters and use_legacy_sql=False

["Olivier Girardot (JIRA)" <ji...@apache.org>]

Olivier Girardot created AIRFLOW-3792:
-----------------------------------------

             Summary: Bigquery hook no longer accepts queryParameters and use_legacy_sql=False
                 Key: AIRFLOW-3792
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-3792
             Project: Apache Airflow
          Issue Type: Bug
          Components: contrib
    Affects Versions: 1.10.2, 1.10.1, 1.10.0
         Environment: any OS but when using BigQuery
            Reporter: Olivier Girardot


Since AIRFLOW-491 with PR [https://github.com/apache/airflow/pull/3733] there is a regression induced that make queryParameters unusable in `BigQueryBaseCursor.run_query` and is a bit inconsistent when `use_legacy_sql` flag is set to false, because it only accepts None even though the parameter is a bool.

For the use_legacy_sql flag there is only a simple condition to add, and for queryParameters the check_param expects a dict but google's api expects a list of dict. c.f. 
|{{configuration.query.queryParameters[]}}|

in [https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs#configuration.query]

PR will soon be opened after this issue 



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