Optimizing SQL Databricks Warehouse Timeout Settings

[Hubert-Dudek]

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.

[Hertz]

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.

[rj_22588]

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?