google-bigquery - BQ 脚本在作曲家中失败

Question

我正在尝试使用 bigquery.Client 运行一个 bq 脚本，但出现以下错误，

语法错误：预期输入结束，但得到字符串文字

    v_minus_statement_s_t="DECLARE dummy_key DEFAULT to_hex(sha256('*nik'));
    DECLARE dummy_value DEFAULT '*nik';
    DECLARE currency_value DEFAULT '$';
    select
    to_hex(sha256(cast(ID as string))) as dw__id,
    to_hex(sha256(cast(ID as string))) as dw_sub_id
    from voice"
    op =client.query(v_minus_statement_s_t).to_dataframe()

标签： google-bigqueryairflowgoogle-api-python-clientgoogle-cloud-composerbq