BigQuery connector for excel - Request failed: Error. Unable to execute query. Timeout while fetching URL

1
votes

I am trying to pull data from BigQuery into Excel. when i run simple and fast queries, everything runs fine. when running "heavy" query that takes long to retrieve i get the following error:

Request failed: Error. Unable to execute query. Timeout while fetching URL: https://www.googleapis.com/bigquery/v2/projects/{my-project}/queries.

the query i can see the query and retrieve its results in the browser tool query history. I manage to retrieve data for simpler queries.

any ideas?

I would believe it has to do with default time out configuration. is there a way to set the timeout parameters for the connector?

Many thanks for your support.

1
exceltimeoutgoogle-bigquery
If you run these queries in the bigquery web ui (bigquery.cloud.google.com), how long do they take? The connector uses appengine, which has some fairly strict timeouts. - Jordan Tigani
Related, how long does Excel take before the timeout occurs? - Michael Sheldon
query takes quite long ~8-10 minutes - N.N.
excel timeout after ~1 minute - N.N.
updated answer below. - Jordan Tigani

1 Answers

1
votes

it looks like the bigquery web connector was not setting a timeout correctly. We have currently updated it to 60 seconds from 15 seconds. 60 seconds is the longest timeout we can use without major restructuring is because the connector is hosted in an appengine app.

Your 8-10 minute query, unfortunately, will not work. One alternative may be to run the query yourself and save the result in a bigquery table (i.e. set a destination table for the query) and then just read that table from excel (i.e. select *).