FRESH DATA FROM DATABRICKS

[Anonymous]

Hi everyone,

I would like to refresh data, the source from 1 sandbox DataBricks (not created by me but I have permission rights) but this message occurs:

OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: '[Microsoft][Hardy] (134) File ***: A retriable error occurred while attempting to download a result file from the cloud store but the retry limit had been exceeded. Error Detail: File ***: An error had occurred while attempting to download the result file.The error is: [Microsoft][DriverSupport] (1120) SSL verification failed because the server host name specified for the connection does not match the "CN" entry in the "Subject" field or any of the "DNS Name" entries of the "Subject Alternative Name" field in the server certificate.. Since the connection has been configured to consider all result file download as retriable errors, we will attempt to retry the download.'..

The source is:

= DatabricksMultiCloud.Catalogs("dbc-***.cloud.databricks.com", "/sql/***/***", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null])

I try to add  [EnableQueryResultDownload="0"] as solved previous topic but did not work

= DatabricksMultiCloud.Catalogs("dbc-***.cloud.databricks.com",[EnableQueryResultDownload="0"] , "/sql/***/***", [Catalog=null, Database=null, EnableAutomaticProxyDiscovery=null])

Please help

Thank you in advance!

[Anonymous]

thanks team

[Anonymous · Accepted solution]

Hi @Anonymous ,
Based on your description and the error information provided, the SSL validation failure appears to be the root cause of the problem. This usually happens when the server's SSL certificate does not match the hostname specified in the connection or the certificate is not trusted by the customer's system.
To solve this problem, you can try the following steps:
First, make sure that the server hostname specified in the connection string matches either the CN (common name) entry or the DNS name entry in the Subject Alternative Name field of the server SSL certificate. Secondly, SSL validation failures can also be due to the system not trusting the certificate. You may need to add the server's SSL certificate to your system's trusted certificate store.
You can refer to the following documents for more information
ssl - Adding Self Signed Certificate to trusted root certificate store using Command Line - Super User

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly