https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/103619#M41520 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="srtiemann1_0-1735586550774.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/13779i15E1A2C83058D458/image-size/medium?v=v2&amp;px=400" role="button" title="srtiemann1_0-1735586550774.png" alt="srtiemann1_0-1735586550774.png" /></span></P><P>&nbsp;</P> Mon, 30 Dec 2024 19:24:48 GMT srtiemann1 2024-12-30T19:24:48Z https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102500#M41146 <P>How can I block the use of statement_timeout at the session level in Databricks? I want the global parameter to be enforced even if a SET statement_timeout has been executed in Databricks notebooks."</P><P>&nbsp;</P> Wed, 18 Dec 2024 14:30:52 GMT https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102500#M41146 srtiemann 2024-12-18T14:30:52Z https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102501#M41147 <P>To set a workspace-level timeout, go to the workspace admin settings, click&nbsp;<STRONG>Compute</STRONG>, then click&nbsp;<STRONG>Manage</STRONG>&nbsp;next to&nbsp;<STRONG>SQL warehouses</STRONG>. In the&nbsp;<STRONG>SQL Configuration Parameters</STRONG>&nbsp;setting, add a configuration parameter where the timeout value is in seconds.<BR /><BR /><A href="https://docs.databricks.com/ja/sql/language-manual/parameters/statement_timeout.html" target="_blank">https://docs.databricks.com/ja/sql/language-manual/parameters/statement_timeout.html</A>&nbsp;</P> Wed, 18 Dec 2024 14:47:28 GMT https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102501#M41147 Walter_C 2024-12-18T14:47:28Z https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102576#M41164 <P>I did this, but when a user uses the set statement_timeout command in their own Databricks notebook, the query exceeds the time determined by the global parameter</P> Wed, 18 Dec 2024 20:26:42 GMT https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102576#M41164 srtiemann 2024-12-18T20:26:42Z https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102577#M41165 <P>Is the notebook pointing to an SQL warehouse or it is pointing to an all purpose cluster or serverless compute?</P> Wed, 18 Dec 2024 20:30:09 GMT https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102577#M41165 Walter_C 2024-12-18T20:30:09Z https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102579#M41166 <P><SPAN>serverless&nbsp;compute SQL</SPAN></P> Wed, 18 Dec 2024 20:33:34 GMT https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102579#M41166 srtiemann 2024-12-18T20:33:34Z https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102584#M41169 <P>To revalidate this, are you using Serverless SQL Warehouse or Serverless Compute which are different? Can you share an screenshot of the compute being used to make sure we are aligned?</P> Wed, 18 Dec 2024 21:08:15 GMT https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/102584#M41169 Walter_C 2024-12-18T21:08:15Z https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/103619#M41520 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="srtiemann1_0-1735586550774.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/13779i15E1A2C83058D458/image-size/medium?v=v2&amp;px=400" role="button" title="srtiemann1_0-1735586550774.png" alt="srtiemann1_0-1735586550774.png" /></span></P><P>&nbsp;</P> Mon, 30 Dec 2024 19:24:48 GMT https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/103619#M41520 srtiemann1 2024-12-30T19:24:48Z https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/103627#M41523 <P>Yes, this global config only applies to Serverless SQL Warehouses, but wont apply if you use serverless compute for notebooks&nbsp;</P> Mon, 30 Dec 2024 21:24:17 GMT https://community.databricks.com/t5/data-engineering/shouldn-t-the-global-statement-timeout-parameter-prevail-over/m-p/103627#M41523 Walter_C 2024-12-30T21:24:17Z