Managing data access

Data can be stored in many different ways and in many different storage mediums. The two most popular data stores on Azure are SQL Database and Azure Data Lake Gen2.

Certain resources, such as a data lake or SQL databases, provide more granular access to the data contained inside these stores. Let’s cover some aspects of data-level access management, as this is key to providing granular access in a data mesh.

In this section, let’s see how we can control access to data stored in these two data stores.

SQL Database

Assuming that the peripheral network security of a database is in place, you should focus on the data security aspect of a data mesh. Authentication in Azure SQL Database can be set up in two ways: SQL Authentication and Azure Active Directory authentication. Assuming you have enabled Azure Active Directory for your Azure tenant, it is recommended that you implement Azure Active Directory-based authentication for SQL Database...