There are 4 places that a timeout might be enforced:
Cloud + Self-hosted:
- 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
-
Any load balancers setup are a common cause, which should by default be set to 60 seconds but varies case by case.
-
If these setting doesn’t work after restarting retool, the service itself might have its own timeout settings.