Optimizing SQL Databricks Warehouse Timeout Settings
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2023 12:34 PM
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.

My blog: https://databrickster.medium.com/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2024 07:04 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2024 07:48 AM
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?