SSL connection with Azure MySQL database

[ghost]

Hello!

I wanted to ask if there is a way to connect to Azure MySQL with SSL as a backend? In my case my SQLALCHEMY_DATABASE_URI would have to be like mysql://user@server:pass1234@server.mysql.database.azure.com:3306/superset?ssl_ca=BaltimoreCyberTrustRoot.crt.pem.
I'm a bit of a beginner to Docker, so I don't know how I could pass that cert. Is there way to do that through superset_config.py or by extending Dockerfile and downloading it to some directory (and which directory it would be)?

Any help or tips are deeply appreciated. Thanks!

[kensixx]

Maybe you could use volumes to mount the crt.pem file to the Docker container of this Superset image,

Then use something like this in the SQLALCHEMY_DATABASE_URI field in superset_config.py