BigQuery Python Client Library - Named Parameters Error

Question

I'm trying to write a simple query using the Python client library named "parameter", but kept encountering errors.

I keep getting "Undeclared query parameters" when I try to run the code. Did I miss out anything?

My Code:

import datetime
import os
from google.cloud import bigquery

os.environ["GOOGLE_APPLICATION_CREDENTIALS"]=<path>
client = bigquery.Client(project='project_id')

query = """
    SELECT * from `<project_id>.<dataset_id>.*` 
    WHERE CAST(REGEXP_EXTRACT(_TABLE_SUFFIX, r"^(\d{8})$") AS INT64) = @date
    limit 10;
    """

query_params = [
    bigquery.ScalarQueryParameter(
        'date', 
        'INT64', 
        int((datetime.date.today().strftime('%Y%m%d'))
        )
    ]

job_config = bigquery.QueryJobConfig()
job_config.query_parameters = query_params

query_job = client.query(
    query,
    location = 'US') 

for row in query_job:
    print(row)

assert query_job.state == 'DONE'

VictorGGl · Accepted Answer · 2018-07-03 10:53:17Z

1

It looks like you are missing to enter your job_config into the arguments of your client.query() method. You should have:

query_job = client.query(
    query,
    location = 'US',
    job_config=job_config)

Official docs here.

answered Jul 3, 2018 at 10:53

VictorGGl

1,90113 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

BigQuery Python Client Library - Named Parameters Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related