Principle could not be found or this principal type is not supported – Azure SQL Database
Cause
Azure Data Factory is missing a managed identity. This error might appear when trying to grant access to Azure Data Factory on the Azure SQL database.
Solution
System Assigned Managed identity for Azure Data Factory will be automatically created when we create it through the Azure portal or PowerShell. If you do not find the managed identity of Azure Data Factory, you can create it using the below PowerShell command. You would need the Az PowerShell module installed on the local machine.
#Generate managed identity for Data Factory.
Set-AzDataFactoryV2 -ResourceGroupName $resourceGroupName -Name $factoryName -Location $location
You can also achieve this in the Azure portal. You can go to the Azure Data Factory in the Azure portal and enable the managed identity for the data factory, as shown in the image below. This will create a managed identity for the data factory in Azure Active Directory.
Pro tips:
1. Learn how to access Azure SQL from Azure Data Factory using the managed identity.
Kunal Rathi
With over a decade of experience in data engineering and analytics, I've assisted countless clients in gaining valuable insights from their data. As a dedicated supporter of Data, Cloud and DevOps, I'm excited to connect with individuals who share my passion for this field. If my work resonates with you, we can talk and collaborate.
I am always interested in new challenges so if you need consulting help, reach me at kunalrathi55@gmail.com.