Book Image

Azure Databricks Cookbook

By : Phani Raj, Vinod Jaiswal
Book Image

Azure Databricks Cookbook

By: Phani Raj, Vinod Jaiswal

Overview of this book

Azure Databricks is a unified collaborative platform for performing scalable analytics in an interactive environment. The Azure Databricks Cookbook provides recipes to get hands-on with the analytics process, including ingesting data from various batch and streaming sources and building a modern data warehouse. The book starts by teaching you how to create an Azure Databricks instance within the Azure portal, Azure CLI, and ARM templates. You’ll work through clusters in Databricks and explore recipes for ingesting data from sources, including files, databases, and streaming sources such as Apache Kafka and EventHub. The book will help you explore all the features supported by Azure Databricks for building powerful end-to-end data pipelines. You'll also find out how to build a modern data warehouse by using Delta tables and Azure Synapse Analytics. Later, you’ll learn how to write ad hoc queries and extract meaningful insights from the data lake by creating visualizations and dashboards with Databricks SQL. Finally, you'll deploy and productionize a data pipeline as well as deploy notebooks and Azure Databricks service using continuous integration and continuous delivery (CI/CD). By the end of this Azure book, you'll be able to use Azure Databricks to streamline different processes involved in building data-driven apps.
Table of Contents (12 chapters)

Creating ACLs using Storage Explorer and PowerShell

We use ACLs when we want to selectively give access to a set of directories and files to AAD users and groups in an ADLS Gen-2 storage account. Neither Azure built-in roles nor custom roles can't be used to restrict access at the directory/file level. Using ACL, we can provide access to specific directories and files in a container. Each file and directory in a Storage Account has an ACL.

Sets of permissions such as reading and writing can be granted to a security group in AAD, to an individual user on directories and files in an ADLS Gen-2 Storage Account, or to a container to restrict the access to the data that a user can see. You can't use an ACL to provide a level of access that is lower than a level granted by an Azure built-in role assignment (RBAC).

Getting ready

Before getting started, make sure you are the owner of the Storage Account or have Storage Blob Data Owner access to the storage account.

There...