How to register and scan ADLS Gen2 and Azure SQL Database in Microsoft Purview?

In this blog, we will learn how to register and scan ADLS Gen2 and Azure SQL Database in Microsoft Purview. First, we will learn the concept of managed identity and how Azure purview uses it. Second, we will learn the steps involved in registering ADLS Gen2. Third, we will learn how to register an Azure SQL DB. In this, we will learn the best practice of storing the Azure SQL DB credentials in an Azure Key Vault and use that Key Vault in Microsoft Purview.

Azure Purview Managed Identity

When building cloud applications these are the common challenges:

  • How to manage the credentials in your code for authenticating to cloud services.
  • Credentials should never appear on developer workstations and aren’t checked into source control.

Azure Key Vault provides a way to securely store credentials, secrets, and other keys, but your code must authenticate to Key Vault to retrieve them. Managed Identities is an Azure resource feature found in Azure Active Directory (Azure AD) that solves this problem.

You can use the identity to authenticate to any service that supports Azure AD authentication, including Key Vault, without any credentials in your code. The managed identities for Azure resources feature is free and there’s no additional cost. We will use Azure Purview Managed Identity.

Register and scan an Azure Data Lake Storage Gen2 account

We have to follow these steps to register and scan ADLS Gen 2 account:

  1. Grant the Azure Purview Managed Identity access to ADLS Gen2 so purview can have access to it. Preview managed identity should have storage blob reader permission on ADLS Gen2
  2. Upload Data to ADLS Gen2 Account so we have adequate data to scan.
  3. Create a Collection in Azure Purview.
  4. Register a Source (ADLS Gen2) in Purview.
  5. Scan ADLS Gen2 with the Purview Managed Identity registered in step 1
  6. Verify if you can see the ADLS Gen2 assets in Purview

Register and scan an Azure SQL Database

We have to follow these steps to register and scan Azure SQL Database:

  1. Grant your Azure Account access to Key Vault by adding a new access policy. We will have to grant all the secret permissions.
  2. Grant Purview Managed identity access to Key Vault by adding a new access policy. Here we will have to grant Get and List permissions so purview can get(retrieve) and list down all the secrets.
  3. Generate a Secret for SQL Admin in Azure Key Vault. This secret will be used to log in to Azure SQL DB.
  4. Generate a Secret for SQL Admin in Azure Key Vault. This secret will be used to log in to Azure SQL DB.
  5. Add SQL Credentials (created above) in Purview so we can use the same credential.
  6. Register Azure SQL DB in Microsoft Purview.
  7. Scan Azure SQL Database as a data source with Azure Key Vault Credentials.
  8. Verify that Purview is able to see tables in the Azure SQL database.

I hope this was useful and you enjoyed it.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.