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)
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 600 seconds but varies case by case.
If these setting doesn’t work after restarting retool, the service itself might have its own timeout settings.