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 the session level using the SET statement and at the global level using Configure SQL parameters or SQL Warehouses API.

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

Examples 

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

-- Set a workspace-level timeout
> STATEMENT_TIMEOUT 86400