JobExecutingException: Reason:responseTooLarge. Message:Response too large to return.
Consider setting allowLargeResults to true in your job configuration. For more details,
see https://cloud.google.com/bigquery/querying-data#largequeryresults
zu write_to_table
allow_large_results=True
Hinzufügen
https://github.com/tylertreat/BigQuery-Python/blob/master/bigquery/client.py#L1032
***.py
client = get_client(PROJECT_ID,
service_account= SERVICE_ACCOUNT,
private_key_file=key,
readonly=False)
...
job = client.write_to_table(query, allow_large_results=True)
...
try:
job_resource = client.wait_for_job(job, timeout=360)
print job_resource
except BigQueryTimeoutException:
print "Timeout"
Recommended Posts