spencer_sa's avatar
spencer_sa
Icon for Impactful Individual rankImpactful Individual
6 months ago
Status:
New

Allow Workspace Identities as an authentication method for Fabric SQL Databases

Currently the only method of authentication in Fabric pipeline connections to Fabric SQL databases is using OAUTH2, meaning that the credentials of a specific user need to be used (with all the attendant issues around user/credential expiry).
By allowing the option of workspace identity for authentication, no user creds would be needed.  Obviously correct access controls would need to be defined, but that's standard SQL Server maintenance.

Data Factory | Connectors
Data Factory | Pipelines
Databases | SQL Database

2 Comments

  • DebbieE's avatar
    DebbieE
    Icon for Community Champion rankCommunity Champion
    5 days ago

    Same need here: our metadata-driven framework’s pipelines use a Fabric SQL database, and the connection can only use OAuth 2.0, so they depend on one person’s account. Workspace identity or service principal support would remove that

Recent ideas