Enable Service Principal Authentication for Lakehouses

[Tom_Fosterbi]

Currently the only option for connecting to a lakehouse using a cloud connection is an organisational account. Adding in Service Principal as an option would avoid the reliance on single user accounts and would bring the lakehouse connector into parity with the warehouse connector.

[patrickstahl]

This is absolutely a must have feature. Production failures because a developers password resets is just not "enterprise ready".

[deborshi_nag]

I agree, SPN authentication to Lakehouse would enable the users to execute a query to be run using the SPN rather than a organisational user account.