sqlserver: Will it support connection via azure service principals instead of username/password

[thomas-svrts]

If I check the code of soda-core I noticed only connection via password/username is possible.
Is it maybe an idea to add support for Azure service principals or Azure Managed identites to connect to Azure sql or Synapse dedicated pools?

In Azure its encouraged to use managed identies or service principals (tenant id, client id, secret).
In our case we installed soda agent on AKS, if we could use managed identities we don't even need to use credentials anymore (https://learn.microsoft.com/en-us/azure/aks/workload-identity-overview?tabs=python)

Here you find documentation how to get access token via Python using service principals: https://github.com/AzureAD/microsoft-authentication-library-for-python or use this lib https://learn.microsoft.com/en-us/python/api/azure-identity/azure.identity?view=azure-python

And that token then can be used to connect via pyodbc which is used by Soda: conn = pyodbc.connect(connString, attrs_before = { SQL_COPT_SS_ACCESS_TOKEN:tokenstruct});

[tools-soda]

SAS-2890