Time out error

[raneenbsaisD]

Hi,

we are using this API to get the data from the query: google-api-services-bigquery-v2

we have clients who have long rows of data: (500 million rows).

we get an error about the time out.

please can you help me to resolve the issue?

[lsolatorio]

Hi @raneenbsaisD,

A software developer from a related post in StakOverflow mentioned that the limit for a query execution was 6 hours, dated October 2016 (documentation stating this fact is not available).

The official documentation for timeoutMs in the Method: jobs.query was also mentioned and it says that (updated definition):

Optional: Specifies the maximum amount of time, in milliseconds, that the client is willing to wait for the query to complete. By default, this limit is 10 seconds (10,000 milliseconds). If the query is complete, the jobComplete field in the response is true. If the query has not yet completed, jobComplete is false

You can request a longer timeout period in the timeoutMs field. However, the call is not guaranteed to wait for the specified timeout; it typically returns after around 200 seconds (200,000 milliseconds), even if the query is not complete.

If jobComplete is false, you can continue to wait for the query to complete by calling the getQueryResults method until the jobComplete field in the getQueryResults response is true.

---

I hope this helped.

Usable resources:
 - Method: jobs.query
 - Method: jobs.cancel