22-25 April 2026
Video unavailable
SQLBits 2022

FIne-Grained Access To Azure Data Lake Storage Gen2

With an enterprise data lake you have multiple authorisation mechanisms. For a tightly controlled level of access, you can use Access Control Lists (ACLs). We will cover ACL permissions and how to store and deploy ACLs from source.
With an enterprise data lake you have multiple authorisation mechanisms to allow users to access the blobs. And whilst Azure RBAC offers a straightforward level of access control, this level of access applies across the entire container and blobs. For a finer-grained level of access, you can use Access Control Lists (ACLs). ACLs require tightly-controlled management and a good understanding of what permissions are required at what level of the directory so that users can access the data they need to. We will have a brief overview of ACL's and focus in greater detail on how to store ACLs in source control and apply the via a deployent pipeline.