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/
on:
UI for Editing Small Lakehouse Tables (Metadata & ...
on:
Power Automate visual in Power BI Desktop does not...
frithjof_v
on:
Job scheduler API: List failed runs