Google BigQuery API Timeout after 10 seconds

We have run into an issue which will stop us to develop any valuable datasets in Spotfire.

So the situation is the following:

1. When I run a query based on a table definition Spotfire kicks out a bigquery#table job which runs fine with no issues

2. When I develop a custom query Spotfire kicks out a bigquery#job job which has a limited DEFAULT response time of 10 seconds.

After that 10 seconds, the BigQuery API response is: "jobComplete": false BUT the query completes within BigQuery, only the API gives back a “I don’t wait more” message

The same happens with BigQuery views except after the 1st run the query result is cached into a temp table and at the 2nd run we receive response with data from the API even if it takes 30 mins to load.

So when we create a custom query with joins and where clause 99% of the time it will take longer than 10sec to run on the server side and the API will deny the data

Please add a timeout parameter to the connection so this setting can be changed if needed.