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 PostgreSQLERROR: canceling statement due to statement timeout
  • In RedShiftERROR: Query canceled on user's request

Currently, this feature is only available for PostgreSQL and RedShift.