Query serverless SQL pool from an Apache Spark Scala notebook

JovanPopthanks for sharing this article. Is it possible to use the workspace Managed Identity for authentication instead of plain username/password? I already tried it using pyodbc and enabling Run as managed identity with having set Authentication=ActiveDirectoryMsi in the connection string, but didn't work, it only works when passing on the user credentials as in your article which raises some security concerns. I have seen the following article doing the same for interacting with the storage by reusing the Linked Service and wonder if there is something similar for  serverless SQL databases: https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/using-the-workspace-msi-to-authenticate-a-synapse-notebook-when/ba-p/2330029

Thanks,

Patrick