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.

3 REPLIES 3

Kaniz
Community Manager
Community Manager
Hi @bradleyjamrozik, It sounds like you’re encountering an issue with the Simba Spark ODBC Driver not properly disconnecting sessions when connecting to Databricks.
 
Let’s explore some potential solutions:
  1. Check Connection Configuration:

    • Ensure that the ODBC connection configuration is correctly set up. You might want to review the connection settings, including the hostname, port, and authentication details.
    • If you’re using a proxy, make sure it’s configured properly. You can configure the Simba ODBC driver with a proxy in Windows by following these steps:
      • Open the ODBC Data Sources application.
      • Click the “System DSN” tab.
      • Select the Simba Spark ODBC Driver and click “Configure.”
      • Enter the connection information for your Apache Spark server.
      • Click “Advanced Options” and enable the “Driver Config Take Precedence” checkbox.
      • Click “OK” to save the changes1.
  2. Access Tokens and Authentication:

  3. SSL and HTTPS Options:

  4. Session Management:

    • Some ODBC drivers allow you to configure session management settings. Check if there are any specific settings related to session timeouts or idle session handling.
    • You might need to adjust these settings to ensure that sessions are properly closed after executing queries.
  5. Driver and Databricks Compatibility:

    • Verify that your Simba Spark ODBC Driver version (2.8) is compatible with the Databricks version you’re using. Sometimes compatibility issues can lead to unexpected behavior.
    • Consider updating the ODBC driver to the latest version if possible.
  6. Logging and Debugging:

    • Enable logging for the ODBC driver to capture any relevant information during connection and query execution. Review the logs for any clues about why sessions are not disconnecting as expected.

Hopefully, one of these suggestions will help resolve the session disconnection problem! 😊🚀45

To ensure we provide you with the best support, could you please take a moment to review the response and choose the one that best answers your question? Your feedback not only helps us assist you better but also benefits other community members who may have similar questions in the future.

If you found the answer helpful, consider giving it a kudo. If the response fully addresses your question, please mark it as the accepted solution. This will help us close the thread and ensure your question is resolved.

We appreciate your participation and are here to assist you further if you need it!

 

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. 

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!