How to import a custom CA certificate into the Databricks SQL module?

[FerArribas]

We need to be able to import a custom certificate (https://learn.microsoft.com/en-us/azure/databricks/kb/python/import-custom-ca-cert) in the same way as in the "data engineering" module but in the Databricks SQL module

[Vivian_Wilfred]

Hi @Fernando Arribas Jara​ Why do you require this for Databricks SQL? AFAIK we do not need this for the SQL warehouse. What is your usecase and what errors/challenges do you face?

[FerArribas]

Hi,

Our use case requires access to data sources in on-premise infrastructure. For this reason, we need to configure the certificates.

Thanks.

[VaibB]

You can try downloading it to DBFS and may be accessing it from there if you use case really needs that.

[FerArribas]

And how do I configure the SQL endpoints that use those certificates? Important: I am referring only to the Databricks SQL module (the data engineering module does allow you to configure these certificates with an init script)