Connecting Pentaho Ctools dashboards to Databricks using JDBC to a serverless dbSQL Warehouse, it works fine on the initial load, but then if we leave it idle for awhile and come back we get this error:
[Databricks][JDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 400, Error message: INVALID_STATE: Invalid SessionHandle: SessionHandle
It seems like maybe we need to set some sort of timeout configuration similar to what is suggested here except I cannot find any documentation about what that would be for dbSQL. Has anyone encountered this?