BigQuery API did not answer query in time
I'm playing around with Windmill Cloud (trial). I've created a BigQuery resource and a SQL script that uses that resource:
When I test the script with certain tables I get "BigQuery API did not answer query in time". Any idea what is going on here?
9 Replies
Do you have the same issue using a big query library in python or typescript ?
Hmm I didn't try directly. Would I just use the resource dict to make the bigquery connection? I was having trouble with:
in python
Ah, fixed with:
Ah yup ok so using the python libraries worked fine
@Hugo when you have time if you could look at that one
we have a timeout of 10s on bigquery queries, should i increase it to 200s (maximum)?
you can increase it to the instance max timeout
the same one we have for normal jobs