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
Visual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley10 minutes agoAdvocate IINew75Views7likes1CommentAdd 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...Kalaiselvan2 hours agoFrequent VisitorNew2Views0likes0CommentsRetain Comments and Formatting in Power Query within Dataflow
I imagine this is part of the pipeline for development of Dataflows by the time it comes out of Preview. Currently all comments and formatting that is written into the Power Query of a Dataflow is st...tmckenzie33 hours agoNew MemberUnder Review317Views22likes4Comments