WiliamRosa
Databricks Partner

Hi @asrivas,
 Looks like the issue is because your MySQL server has --require_secure_transport=ON, so Lakehouse Federation will only connect if SSL/TLS is properly configured. I’d suggest checking if your connection settings (host, port, user, password, database, and especially SSL options) are aligned with the docs — see if your setup matches what’s described here: https://learn.microsoft.com/en-us/azure/databricks/query-federation/mysql
. Also make sure there aren’t any outbound restrictions from the workspace or inbound blocks on the MySQL side. If it still returns an error, please share more details so I can try to simulate it in my environment.

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