Compute configuration : single user with service principal of azure data datafactory ?

[MDV]

Is it possible to have the service principal (ID) of an Azure data factory as the Single user access on an databricks cluster ?

Reason I'm asking is because we are starting to use unity catalog , but would still have the need to execute stored procedures using jdbc on an Azure DB, and this is impossible using Unity Catlog (or if anyone knows a workaround, please share). In single user mode this is possible.

See Running Stored Procedures on a Multi-node/ Shared ... - Databricks Community - 10863

Thanks 

[BigRoux · Accepted solution]

Yes, this is possible. First, create a new service principal in Azure or use an existing one. This could be either a managed identity from Azure Data Factory or a manually created service principal in Microsoft Entra ID (formerly Azure AD). Next, in your Databricks workspace, go to Admin Settings > Service Principals, and add the service principal by entering its Application ID.

Moreover, Databricks supports a single user access mode for clusters, where only one user or service principal has access. This mode is compatible with Unity Catalog and ensures that all operations on the cluster are executed under the identity of the specified user or service principal

Hope this helps.

[MDV]

It worked, but we had to create the cluster using an API call, we couldn't select the service principle as user