Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Azure RBAC can grant broad access to a storage account or container, while ACLs secure individual directories and files.
  • In Fabric, OneLake security roles can grant access only to specific folders or tables, while Admins, Members, and Contributors generally retain broad access within the item

...

SYSM-388 - Evaluate security implications of ADLS Gen2 shortcuts in Fabric

Jira
serverSyensqo's Jira
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,customfield_13736,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,Priority,priority,status,resolution
serverIdd8efc1ef-48bd-3b4e-8714-ad827f4f059b
keySYSM-389

Shortcut-specific access model

QuestionPractical answer
Who authenticates to ADLS?The identity configured on the shortcut
Who authorizes storage access?Azure ADLS
Who authorizes visibility in Fabric?Fabric workspace/item permissions and, when enabled, OneLake security
What happens if both layers apply?The effective access is constrained by both layers; for shortcuts, Fabric documents a most-restrictive logic between shortcut path and target path
Is behavior identical across engines?

No; some scenarios use delegated identity differently, including owner-based access patterns in specific engines

Access flow

Image RemovedImage Added

LayerWhat it controlsExamples
Fabric layerWho can see and use the shortcut inside FabricWorkspace role, item access, OneLake security
Shortcut layerWhich identity is used to reach ADLSWorkspace Identity, Service Principal, Organizational account, SAS, Account Key
Azure layerWhether the target storage path can actually be readRBAC, ACL, firewall / trusted access

...


Shortcut authentification models

Delegated shortcuts access data by using some intermediate credential, such as another user or an account key.

These shortcuts allow for permission management to be separated or 'delegated' to another team or downstream user to manage.

Delegated shortcuts always break the flow of security from one system to another.


Diagram showing the delegated identity used to access the data in the shortcut target.Image Added


...

Latency consideration

Latency view

DimensionWhat it meansShortcut impact
Exposure latencyTime to make data available in FabricLow, because no ingestion copy is required. (Microsoft Learn)
First-read latencyTime for the first query/read to access ADLS dataCan be higher than fully ingested local data because Fabric still reads the external target. (Microsoft Learn)
Repeated-read latencyTime for subsequent reads of the same dataOften improved when cache is used. (Microsoft Learn)
Refresh latencyDelay before changes in ADLS are reflectedDepends on engine and cache refresh behavior; Spark intelligent cache automatically detects underlying file changes. (Microsoft Learn)

Cache Solution for Shortcuts

Mecanism

Image Added


Settings

Info

 Shortcut caching currently supports Google Cloud Storage (GCS), S3, S3 compatible, and on-premises data gateway shortcuts.

Screenshot of workspace settings panel with OneLake tab selected.Image Added