cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Optimizing SQL Databricks Warehouse Timeout Settings

Hubert-Dudek
Esteemed Contributor III

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.

ezgif-1-a917957651.gif

2 REPLIES 2

Hertz
New Contributor II

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
New Contributor II

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? 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group