BigQuery print results in Python

Question

Query Update in BiqQuery on Python

*

def upd_data(QUERY):
    query_job = client.query(QUERY)
    z = query_job.result()
    print(query_job.state, query_job.result, query_job.query_results

*

I get on print - bound method QueryJob.query_results of google.cloud.bigquery.job.QueryJob object at 0x000001CFDEC22748

I need - "N rows affected."

Willian Fuks · Accepted Answer · 2018-03-14 14:13:05Z

2

If you are running DML queries and want to know how many rows were affected then try this instead (this is in client version 0.31 but should work from 0.28):

query = """
  UPDATE table 
  SET col WHERE condition
"""

job = client.query(query)
result = job.result()
print("Total rows affected: ", job.num_dml_affected_rows)

answered Mar 14, 2018 at 14:13

Willian Fuks

11.9k10 gold badges55 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

BigQuery print results in Python

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