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:ย 

ODBC Connection Does Not Disconnect

bradleyjamrozik
New Contributor III

I have an on-premises Power BI Report Server that uses the Simba Spark ODBC Driver (2.8) to connect to Databricks. It can connect to a serverless warehouse successfully and run its queries, but it never seems to disconnect the session, and so the warehouse never registers as "idle" and auto-terminates. Has anyone seen this before? Any suggestions/recommendations? Thanks.

2 REPLIES 2

bradleyjamrozik
New Contributor III

Enabling "Driver Config Take Precedence" seems to be doing something. I'm going to monitor and report back.

bradleyjamrozik
New Contributor III

It's working sometimes. Only correlation I have found so far is that a successful query will disconnect as expected but any error will keep the connection to the warehouse open indefinitely. 

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