W
Windmill•4mo ago
agib

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: 
-- @schema (string)
-- @table (string)

EXECUTE IMMEDIATE FORMAT("SELECT * FROM %s.%s LIMIT 100", @schema, @table)
-- @schema (string)
-- @table (string)

EXECUTE IMMEDIATE FORMAT("SELECT * FROM %s.%s LIMIT 100", @schema, @table)
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
rubenf
rubenf•4mo ago
Do you have the same issue using a big query library in python or typescript ?
agib
agib•4mo ago
Hmm I didn't try directly. Would I just use the resource dict to make the bigquery connection? I was having trouble with: 
from google.cloud import bigquery
from google.oauth2 import service_account
from google.cloud import bigquery
from google.oauth2 import service_account
in python
agib
agib•4mo ago
No description
agib
agib•4mo ago
No description
agib
agib•4mo ago
Ah, fixed with:
No description
agib
agib•4mo ago
Ah yup ok so using the python libraries worked fine
rubenf
rubenf•4mo ago
@Hugo when you have time if you could look at that one
Hugo C.
Hugo C.•4mo ago
we have a timeout of 10s on bigquery queries, should i increase it to 200s (maximum)?
rubenf
rubenf•4mo ago
you can increase it to the instance max timeout the same one we have for normal jobs
Want results from more Discord servers?
Add your server
More Posts
Background Runnable not triggering on App startHi, I have an App that loads the data it needs using a few background runnables that are configured Windmill Server Stuck On Boot [ docker ]After a reboot to caprover, the windmill server stopped working (can't open page). Workers keep workVersioning + DAG order of execution1) the api is versionned but our api viewer/explorer only display the current/last one 2) yes 3) theWorker stuck in migration modeError: Migrating database: while executing migrations: error returned from database: cannot execute Incorrect Run Time Estimation: Seeking Assistance to Correct a 4-Hour MiscalculationOne of my runs indicated that it took 14,831.792 seconds, which is approximately equal to 4 hours. HWhat is the best way to create a service user?We have some nightly test code that will use Windmill as an API for various operations. We'd like toHow to open a modal when selecting a rowHello everyone, can you help me with: How can I make sure that when selecting a row a modal is displRich Display Rendering | WindmillNEW [Major] 🔴 Rich table display *Released on 23/01/2024 under v1.251.1* Display arrays of objechey there, how can one enable `unstable`hey there, how can one enable `unstable` featrues of deno in windmill?Trouble committing file to GitHub but only in bun runtimeI'm trying to create a script to commit font files into my github repository. This is code that is m