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:
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.