add more authentication method for Azure databricks connector copy data and copy job activity
Please add support for additional authentication methods for the Azure Databricks connector in Fabric/Data Factory Copy Data and Copy Job activities. Current documentation shows that Copy supports Personal Access Token authentication, whereas other experiences such as Dataflow Gen2 support additional authentication methods including Microsoft Entra ID.
PAT-only authentication is not sufficient for enterprise production scenarios. PATs introduce challenges around security governance, token rotation, ownership, expiry, and operational support. Databricks also recommends OAuth where possible instead of PATs because OAuth provides stronger security.
In our current Copy Data / Copy Job implementation, we are only able to connect to serverless Databricks SQL/warehouse-style endpoints, and we are not able to use the other Databricks cluster types required for our workloads. This limits flexibility for existing Databricks architectures where teams need to connect to specific non-serverless or interactive compute resources.
Please consider adding support for enterprise authentication options such as:
- Microsoft Entra ID authentication
- Service principal authentication
- System-assigned managed identity
- User-assigned managed identity
This would reduce dependency on PATs, improve security and governance, simplify credential lifecycle management, and provide more flexibility when connecting Fabric/Data Factory Copy activities to Azure Databricks compute.
Recent ideas
Auto-propagate Lakehouse (Direct Lake) permissions to users assigned to a Power BI App audience
Problem When a Power BI report uses a Live Connection to a Direct Lake Semantic Model, end users must have explicit ReadAll / ReadData permissions on the underlying Lakehouse (or its SQL analytics e...majofv43 minutes agoNew MemberNew3Views1like0CommentsAdd a Close or “Return to previous page” button to Semantic Model Security and Settings pages
When updating RLS group assignments through Semantic model > Security, there is no consistent in-product Close or Done button that returns the user to the previous workspace view. The browser Back b...Kalaiselvan3 hours agoFrequent VisitorNew2Views0likes0Comments