Query Timeout - where to look

[Kenny]

There are 4 places that a timeout might be enforced:

Cloud + Self-hosted:

1. The Retool UI Advanced tab can be set to a maximum of 120s (120,000 milliseconds), it cannot be raised higher
   (Note: On Cloud, all queries default to timeout after a maximum of 120 seconds)
   
   
   Also, for some resource types it's not possible to set a timeout in the frontend, so the option may be greyed out.

Self-hosted:
2. DBCONNECTOR_QUERY_TIMEOUT_MS environment variable set to milliseconds

3. Any load balancers setup are a common cause, Virtual Private Connection(VPC), and firewalls which should by default be set to 60 seconds but varies case by case.

4. If these setting doesn’t work after restarting retool, the service itself might have its own timeout settings.