I have several python processes that executes complex sql queries using BigQuery connector.
These queries are executed as one sql file.
Several processes are executing thin file with different input.
The main target table that is being used for all is the same table.

What I see that in some cases one of the update queries is "stuck", instead of 3 minutes execution, its trying to execute it until the time slot has ended and then it fails.

what is the best practice to solve it?