Unable to get Azure Purview Lineage extraction working

Question

In order to get the Lineage Extraction (preview) feature working when running a scan, I had been informed that I need to execute the ''Prerequisites for setting up scan with Lineage extraction" from the following document under ''Lineage(Preview)'': https://learn.microsoft.com/en-us/azure/purview/register-scan-azure-sql-database?tabs=sql-authentication#lineagepreview

![196644-scan-probleem.png][1]

Only, when running the query, I keep getting the following error message. Does anyone happen to have any idea what this is due to? I assume I need to put the name of my purview account in the next query. So the query:

Create user

Answer 1

Hi, @Hicham Thanks for the ask and for using the Microsoft Q&A platform.
As we understand the ask here is you are trying to create a user with a purview account based on the documentation provided and you are facing an issue.

As per the error message "connections established with Active Directory accounts can create other Active Directory users" I want to check if your Azure SQL database has Azure active directory permissions.

I have created it with AAD and it worked fine.

From the scan please select MSI as mentioned in the document

Please let me know if you find any issues.

Regards
Geetha

Answer 2

I have similar issue . I am unable to view lineage for my snowflake account.