To access data stored in ADLS Gen2, we use "External Location" (which is created using Unity Catalog). To achieve this, we make use of Access Connector (which is an Azure Resource). Can we make it possible to create "External Location" using One Lake paths (instead of ADLS Gen 2 only). We can add Access Connectors in the AD groups ( Entra ID) and can define the role of a contributor to that group. This way, that Access Connector would have the access to the One Lake data. And, Databricks is inclined towards Unity Catalog, so it makes sense to follow the standard approach to access the data (using Access Connectors instead of Service Principals).
DM me on LinkedIn for a quick chat - https://www.linkedin.com/in/ansh-lamba-793681184/
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Improve Copy Job Validation Errors When Upsert Keys Are Missing
Improve Copy Job Validation Errors When Upsert Keys Are Missing Product: Microsoft Fabric Area: Data Factory – Copy Job Category: Error Handling / User Experience Problem When adding new tables ...jasonhorner3 hours agoRegular VisitorNew5Views0likes0Comments📉 How Would You Investigate a 20% Drop in Revenue?
A data analyst shouldn’t stop at identifying what happened. The real questions are: Where did the decline occur? → Why did it happen? → What caused it? → What should we do next? By analyzing regio...aliulmurtaza5 hours agoNew MemberNew5Views0likes0CommentsAdd “Don't show this again” option to Power Query Insert Step warning
When a transformation is performed while an earlier Applied Step is selected, Power Query displays the “Insert Step” warning every time. This is useful for new users, but becomes unnecessary for expe...bjs17467 hours agoNew MemberNew4Views0likes0Comments