Skip to main content

STATEMENT_TIMEOUT

Applies to: check marked yes Databricks SQL

The STATEMENT_TIMEOUT configuration parameter specifies a timeout duration in seconds. The count starts at the beginning of the SQL statement's execution. Any Databricks SQL statement with a run time exceeding the value is timed out.

You can set this parameter at three scopes:

Setting​

Set a timeout value in seconds between 0 and 172800 seconds (2 days). Any Databricks SQL statement that has an execution time exceeding the set value is halted.

System default​

The system default is 172800 seconds (2 days).

Precedence​

When the timeout is set at more than one scope, the first non-null value in the following order applies:

  1. Session
  2. Warehouse
  3. Workspace

If the timeout is not set at any scope, the system default applies.

Examples​

The following example sets a session-level timeout and then resets it.

SQL
-- Set a session-level timeout
> SET STATEMENT_TIMEOUT = 86400;
> SELECT * FROM DIAMONDS;

-- Reset the timeout duration
> RESET STATEMENT_TIMEOUT;
> SELECT * FROM DIAMONDS;

To set a workspace-level timeout, go to the workspace admin settings, click Compute, then click Manage next to SQL warehouses. In the SQL Configuration Parameters setting, add a configuration parameter where the timeout value is in seconds.

SQL
-- Set a workspace-level timeout
> STATEMENT_TIMEOUT 86400

Notes​

For information about setting, removing, and checking a warehouse-level timeout, see Statement timeout.