The query timeout can be controlled in workflows just fine for us.
Was it always disabled in the apps?
I am getting around the disable by importing my MS SQL Server query into the /query library/ where I am allowed to set timeout.
Hi @redhat00,
Unfortunately, we don’t support per query timeouts for MS SQL app queries. It looks like this is because the node-mssql sdk can't support timeouts on a query level.
I will file a bug report to make this more clear in the query library. If needed, we recommend setting the timeout on the resource itself (outside of Retool). Otherwise, for Cloud accounts, MS SQL app queries will have a 2 minute timeout in Retool. For folks on self hosted accounts, the value you have set for environment variable DBCONNECTOR_QUERY_TIMEOUT_MS will be what is respected here.
1 Like