topic Optimizing SQL Databricks Warehouse Timeout Settings in Warehousing & Analytics

Optimizing SQL Databricks Warehouse Timeout Settings

Hubert-Dudek — Mon, 04 Sep 2023 19:34:56 GMT

Did you know the default timeout setting for SQL #databricks Warehouse is two days?

The default timeout can be too long for most use cases. You can easily change this for your session or in the general SQL warehouse configuration.

Re: Optimizing SQL Databricks Warehouse Timeout Settings

Hertz — Wed, 05 Jun 2024 14:04:00 GMT

If the default is set to 2 days why would my tableau extract refresh jobs that utilize and sql warehouse time out due to inactivity after 10 or 20 mins.

Re: Optimizing SQL Databricks Warehouse Timeout Settings

rj_22588 — Thu, 22 Aug 2024 14:48:34 GMT

Hi @Hubert-Dudek we have a java service which uses JDBC Template for connecting to databricks warehouse. We recently set a high connection idle timeout and maxLifeTime for our hikari pool connection. We are now seeing error related to invalid session and doubt that databricks sessions might be expirying as connections are existing for quite a long time now. Can you suggest where can I find the current session timeout value for such db connections?