WiliamRosa
Databricks Partner

Hi @asrivas , I’ve been trying to simulate this on my side and in my case I was able to complete the connection, but I believe in your case the issue comes from the MySQL setting --require_secure_transport=ON. In the notebook it works because the driver handles SSL params more flexibly, but with Lakehouse Federation you need to either check the Trust server certificate box or append ?SSL=true&trustServerCertificate=true in the host field. If it still doesn’t work, it may be that your instance requires a valid certificate instead of just trusting, so you’d need to configure the CA cert on MySQL or make sure Federation is able to recognize it.

Wiliam Rosa
Data Engineer | Machine Learning Engineer
LinkedIn: linkedin.com/in/wiliamrosa