Connection Timeout Setting
Query Timeout#
Sometimes your query takes too much time and resource. With this setting, you can set up a timeout limit to abort any query that runs for more than a specified number of milliseconds.
Open the data source setting and enter the limit time in milliseconds:
How It Works#
When your query reaches the timeout limit, an error will be raised, and depend on your database the message will be:
- In PostgreSQL:Â
ERROR: canceling statement due to statement timeout - In RedShift:Â
ERROR: Query canceled on user's request
Currently, this feature is only available for PostgreSQL and RedShift.