I’m looking to automate ACL (Access Control List) creation in Azure Data Lake. Currently, our process involves creating ACLs manually, then utilizing the propagate ACL feature. However, we’re encountering challenges ensuring users have the necessary permissions.

Our requirement is for users to have read-execute (r-x) permissions on all root folders to browse to subfolders where they have read-write-execute (rwx) permissions.

Is there a recommended or “correct” way to set up ACLs in Azure Data Lake to achieve this seamlessly and efficiently? Any insights or best practices would be greatly appreciated. Thank you!