Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,040 questions
While running SQL query in Azure Databricks workspace i.e. on SQL warehouse as well as on UC enabled shared cluster facing an SSL handshake error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 24%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ashwini Gaikwad
110
Reputation points
Hello Team,
We have UC enabled Azure databricks workspace, also the Public access and delta sharing is disabled on our workspace. So while running the below SQL query on SQL Warehouse as well as on UC enabled shared cluster, I am receiving an error.
Please find the query ran on notebook and the error below for your reference
%sql
select workspace_id, entity_id from system.access.table_lineage where entity_type in ('NOTEBOOK') and source_table_catalog != 'system' and source_table_catalog in ('main','test_d') and target_table_catalog in ('main','test_d')
FileReadException: Error while reading file delta-sharing:/91a41d8e4d35b3bdebb6ecdcca04089f166a2fd59888ba6fc39d0fe8563a4a49.uc-deltasharing%253A%252F%252Fsystem.access.table_lineage%2523system.access.table_lineage_20240628_090343_466a14b8/xxxxxxxxxxxxxxxxxxxxxxxxxxxxx/3391xxxxx. Caused by: SSLHandshakeException: Remote host terminated the handshake Caused by: EOFException: SSL peer shut down incorrectly
Request you to please let me know how to resolve this issue.
Regards,
Ashwini Gaikwad
{count} votes
-
PRADEEPCHEEKATLA-MSFT 83,891 Reputation points Microsoft Employee2024-06-28T11:36:21.7766667+00:00 @Ashwini Gaikwad - Thanks for the question and using MS Q&A platform.
Based on the information you provided, it seems like you are encountering an SSL handshake error in Azure Databricks when running your SQL query. This error can be caused by several factors, including network configuration, certificate issues, cluster configuration, and delta sharing settings.
To troubleshoot and potentially resolve the issue, you can follow these steps:
Step 1: Check Network Configuration Ensure that your network settings allow outgoing SSL connections to the Azure Databricks endpoints. You may need to update firewall rules or network security groups.
Step 2: Update Certificates If there are updates or patches available for Azure Databricks, apply them. Ensure that the certificates used for SSL connections are current.
Step 3: Verify Cluster Configuration Review the cluster configuration to ensure there are no conflicting settings. You can try restarting the cluster to apply any new configurations.
Step 4: Review Delta Sharing Configuration Since delta sharing is disabled, make sure your query and environment are not referencing delta-sharing settings that could be causing the issue.
If none of the above step's work, it is possible that Azure Databricks is blocking the system to connect to the server. In this case, you may need to open a support ticket for further assistance.
I hope this helps! Let me know if you have any further questions.
-
Ashwini Gaikwad 110 Reputation points
2024-06-28T12:13:51.81+00:00 Hello @PRADEEPCHEEKATLA-MSFT Thank you for your email.
Step1 : Which specific network setting of firewall or nsg rule need to be in place so that to allow outgoing SSL connections to the Azure Databricks endpoints. Can you share some reference article?
Step 2: Update Certificates If there are updates or patches available for Azure Databricks, apply them. Ensure that the certificates used for SSL connections are current - We have not uploaded any specific certificate manually, is there a need of it? can you share the reference article for the steps to follow.
Step 3: Done
Step 4: Review Delta Sharing Configuration Since delta sharing is disabled, make sure your query and environment are not referencing delta-sharing settings that could be causing the issue. - If you see the sql query which I mentioned in the question, I am not requesting/sharing anything related to delta-sharing settings.
Regards,
Ashwini Gaikwad
-
PRADEEPCHEEKATLA-MSFT 83,891 Reputation points Microsoft Employee
2024-07-01T05:39:55.8333333+00:00 @Ashwini Gaikwad - I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us?
Sign in to comment